topic Using a String Variable with Set Expressions in QlikView

Using a String Variable with Set Expressions

Mon, 01 Apr 2013 15:15:30 GMT

Hi Folks:

CAn't get this to work. Result is always nothing.

Set Varx ="ACME INC";

=If (Count ( {$<[Install Site GU Company Name]={'$(Varx)'}>} [Serial Number])>0, Count ( {$<[Install Site GU Company Name]={'$(Varx)'}>} [Serial Number]))

Thanks.

Re: Using a String Variable with Set Expressions

jagan — Mon, 01 Apr 2013 15:45:25 GMT

Hi,

This expression is working, seems it is similar to yours.

Set Varx = 'a';

Expression = Sum({<[Student id]={'$(Varx)'}>} Mark1)

What are the dimensions you are using? Can you attach sample file?

PFA, hope it helps you.

Regards,

Jagan.