Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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)