topic Re: Variable in set analysis Modifier in QlikView

Variable in set analysis Modifier

rajeshvaswani77 — Tue, 09 Jul 2013 10:47:04 GMT

Hi All,

I have an set expression where the left hand side of the modifier is a variable. However this does not seem to work.

=count({$<"$(=$(varIncurred))"={'<1000000'}>} distinct UCR)

I have used $ expansion for the variable, the modifier is ignored and i get count of distinct UCR's

could someone please suggest a correct way of doing this.

thanks,

Rajesh Vaswani

Re: Variable in set analysis Modifier

Tue, 09 Jul 2013 10:51:10 GMT

For this case simple 'IF' condition is enough.

=Count(Distint IF(varIncurred<10000000,UCR))

Karthik

Re: Variable in set analysis Modifier

Gysbert_Wassenaar — Tue, 09 Jul 2013 10:54:59 GMT

You can only use field names on the left hand side. So unless the variable resolves to a field name it won't work.

And you'll have to explain what you're actually trying to do. I have no idea what problem you're attempting to solve. Please post sample data and what the result of the calculation should be. Maybe

these two documents can help you tell us what you want: