topic Re: String variable in Set Analysis in QlikView

String variable in Set Analysis

dafnis14 — Wed, 21 May 2014 18:39:33 GMT

Hi All,

I can't figure out why the following Set Analysis example doesn't work:

Temp:
LOAD * INLINE [
Code, Status, Amount
9,A,100
3,B,200
6,A, 500
1,A,100
2,B,200
4,A, 500
];

I have defined a variable vStatus that can be either A or B:

IF(DAY(Today()) >15,'A', 'B')

The following expression doesn't work. The result is 0.

(I have tried all kinds of variations Of writing the variable).

sum({<Status = {'$vStatus'} >} Amount)

Your kind help is highly appreciated.

Thanks!

Message was edited by: Dafnis X Attached is my file. Thanks

rogerioqv — Wed, 21 May 2014 18:57:05 GMT

Dafinis,

Following example

swuehl — Wed, 21 May 2014 18:57:51 GMT

Try either

Status = {'$(vStatus)'}

Status = {'$(=vStatus)'}

Wed, 21 May 2014 18:59:09 GMT

Hey see the attached file.

maxgro — Wed, 21 May 2014 19:11:43 GMT

sum({<Status={$(vStatus)} >} Amount)

dafnis14 — Wed, 21 May 2014 19:19:59 GMT

Hi,

You can see that the various options aren't working..

I can't open the files sent by you kind people until tomorrow ...

Thanks!

swuehl — Wed, 21 May 2014 19:22:35 GMT

Use an equal sign first in your variable definition

dafnis14 — Wed, 21 May 2014 19:25:14 GMT

Thanks!

Anonymous — Wed, 21 May 2014 19:26:36 GMT

See attached