Variable in set analysis Modifier

[rajeshvaswani77]

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

[#2]

For this case simple 'IF' condition is enough.

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

Karthik

[Gysbert_Wassenaar]

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:

• QlikCommunity Tip: How to get answers to your post?
• Preparing examples for Upload - Reduction and Data Scrambling.