4 Replies Latest reply: Aug 29, 2018 10:00 AM by vamsee duggirala RSS

    Date Trim/Merg

    Solomon Adjei

      Hello Qlik family,

       

      I am new to this forum and qlikview in general and I have a question I really want to know the answer to.

      Am developing an app with date format like the one below in my data,

       

      [Original data]

      12/04/2016

      01/04/2017

      10/04/2018

       

      I have also created a seperate data with date format like

       

      [Created data]

      YEAR

      2016

      2017

      2018

       

      MONTH

      01

      02

      03

       

      I really want to know is there a way or possibility to trim the date in my original data to link  it to my created data to do the magic ??

      so for email: when I click just [2017] or the month [01] it will give me all the dates relates to my origianl data or it will link both dates together.. ???

       

      Thanks