3 Replies Latest reply: Aug 6, 2018 12:44 AM by Petter Skjolden RSS

    Is there any issue with the E() and P() in qliksense

    Rahul S

      Hi All, I would like to use my qlikview expressions in qlik sense.

      I am using the following expression in qlikview and qliksense.

       

      Sum({<Fin_Year_Set= {'$(=vmaxyear-1)'}, phoneno= e({<sales={'>0'}, Fin_Year_Set = {'$(= vmaxyear)'}>}) >} sales)

       

      That is I would like to get previous year sales, but I want to exclude those phone no who have purchased in the current year.

       

      The expression is perfectly working in qlikview, but not in qliksense with the same data set. In all expressions, everything is working fine apart from p() and e().

       

      Please help.

       

      Regards

      Rahul