Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)@
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)