1 Reply Latest reply: Mar 26, 2018 7:55 AM by vinaykumar HG RSS

    Need help - table query, based on condition show in table - Qliksense

    vinaykumar HG

      we know how to do it in Qlik View, ass conditional dimension,

      based on the month selection single or multiple, onfly we need to populate the table data.

      please help..

       

      for eg in below data if I select month as Jan2016 to feb2016, then I need max month record in jan and feb for project A & B I need

      on below data my result should be,

      A, Feb2016

      B,Feb2016

       

      if nov2015 to dec2015

      A, Dec2015

      B,Nov2015 (as no dec 2015 data)

       

      month selected may be 2 months or more. max month record shoul appear with remaining column on fly.. please help.

       

         

      ProjectID([Month])DN_TrendDatexStagetotal
      ANov 201501-11-15 0:00--0
      ADec 201501-12-15 0:00--0
      AJan 201601-01-16 0:000013
      AFeb 201601-02-16 0:000113
      AMar 201601-03-16 0:000114
      AApr 201601-04-16 0:000114
      AMay 201601-05-16 0:000214
      BDec 201501-12-15 0:00--0
      BJan 201601-01-16 0:00-00
      BFeb 201601-02-16 0:00010
      BMar 201601-03-16 0:00010
      BApr 201601-04-16 0:00010
      BMay 201601-05-16 0:00010
      BJun 201601-06-16 0:00010
      BJul 201601-07-16 0:00010
      BJan 201701-01-17 0:00010
      BFeb 201701-02-17 0:00010
      BMar 201701-03-17 0:00010