Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

subrato123
New 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
Esteemed Contributor

Re: Set analysis not working in qlik sense

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)

Community Browser