Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
subrato123
Partner - Contributor III
Partner - Contributor III

Set analysis not working in qlik sense

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)@

1 Reply
OmarBenSalem

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)