topic Re: Comparing a variable in set analysis is not working in QlikView

Comparing a variable in set analysis is not working

archire2102 — Wed, 28 Mar 2018 02:05:36 GMT

Hi,

I am trying to put a condition where the value of variable should be less than or equals to 30 within set analysis with other conditions as well:

[$(vSoaInterval)] = {'<=30'}

This doesn't seem to work.

Re: Comparing a variable in set analysis is not working

sunny_talwar — Wed, 28 Mar 2018 14:42:11 GMT

What is the definition for vSoaInterval? If it is an expression... like Sum(Measure)... it won't work because you cannot have functions on the left hand side of a set modifier.... Would you be able to share some sample data and what is that you are trying to get out of it?

Re: Comparing a variable in set analysis is not working

archire2102 — Wed, 28 Mar 2018 23:46:13 GMT

Hi Sunny,

Thanks for your reply. The reason why it wasn't working is that it had multiple values and variable can store only 1 value.