1 Reply Latest reply: Nov 28, 2017 6:20 AM by omar bensalem RSS

    Set analysis not working in qlik sense

    SUBRATO KUMAR

      I tried a set analysis measure in qlikview which excuted correctly but in qlik sense its giving NO result. Unable to Solve it. I used 2 variables:

      Var_Selected_12Months ,which calculate  12 months back from current selection like 201603 and

      Var_Selected_YearMonth ,which calculate current selection like 201703

      Trying to find the values  of sum(firstpassvolume2)/ sum(inputvolume2) on the set theory:

       

      Sum({$<scheduledmeterreadingdate_yyyymm={">$(=$(Var_Selected_12Months))<=$(=$(Var_Selected_YearMonth))"}>}firstpassvolume)/

      Sum({$<scheduledmeterreadingdate_yyyymm={">$(=$(Var_Selected_12Months))<=$(=$(Var_Selected_YearMonth))"}>}inputvolume)@

        • Re: Set analysis not working in qlik sense
          omar bensalem

          what's the result of ur expression?

          And how are the variables defined? with '=' or without?

           

          what if u try this?

          Sum({$<scheduledmeterreadingdate_yyyymm={">$(Var_Selected_12Months)<=$(Var_Selected_YearMonth)"}>}firstpassvolume)/

          Sum({$<scheduledmeterreadingdate_yyyymm={">$(Var_Selected_12Months)<=$(Var_Selected_YearMonth)"}>}inputvolume)