11 Replies Latest reply: Feb 6, 2018 4:46 AM by max payne RSS

    Is this bug in qliksense

    max payne

      Hi,

       

      I am facing little weird behavior in  qliksense w.r.t qlikview expression.

       

      Let me explain in detail

      1: My Source data

       

      YearSales
      2017200
      2016100
      2015300
      2014120
      2013300
      2012400
      2011234

       

      2 :

      my load script is like below in qliksense (similar in qlikview)

      [Sheet2]:

      LOAD [Year],

      [Sales],

          Right(Year,2)-1&'-'&Right(Year,2) as Fin_Year

      FROM [lib://Desktop/Book1.xlsx]

      (ooxml, embedded labels, table is Sheet2);

       

       

      3:

      For PY YTD my set analysis expression is

      =Sum({<Year={"$(=max(Year)-1)"}>}Sales)

       

      4.1 : In QlikView

      When User Select value from Fin_Year It is showing correct PY YTD

      For Example : If User select 16-17, Text object return 100

       

      Working as expected

       

      When User select value from Year from Year field then it is showing correct PY YTD

      For Example : If User select 2017, Text object return 100

       

      Working as expected

       

      4.2 : QlikSense

      When User select value from Year from Year field then it is showing correct PY YTD

      For Example : If User select 2017, Text object return 100


      Working as expected


      When User Select value from Fin_Year It is showing 0

      For Example : If User select 16-17, Text object return 0

       

      Not Working as expected.


      Can some one help me to understand this behavior.


      gwassenaar, swuehl, mbaeyens, kaushik.solanki


      Regards,