topic Re: Set analysis with <= operator in QlikView

Set analysis with <= operator

Wed, 06 Jun 2012 12:40:34 GMT

Hello @ all,

I have a set analysis expression that counts field values based on the selection of a week (in field 'week') and all weeks before.

Strange thing it works with a variable, but not with the field in the set analysis:

=count( {$<week= {"<= $(=Selected_Week) "} >} NR) --> this works, field value of 'week' is represented by variable 'Selected_Week'

=count( {$<week={"<=week"}>} NR) --> this returns always 0

Any ideas how to get it to work with the field value instead of the variable value?

Thanks, Eva

jagan — Wed, 06 Jun 2012 12:48:49 GMT

Hi,

Try this expression

=count( {$<week={"<=$(=Max(week))"}>} NR)

Hope this helps you.

Regards,

Jagan.

Wed, 06 Jun 2012 13:03:34 GMT

Hi Jagan,

this works!

Thank you,

Eva

jagan — Wed, 06 Jun 2012 13:10:00 GMT

Hi,

Close this discussion by clicking Correct Answer button, it helps others to find the answer for similar issues.

Regards,

jagan.