topic Re: Variable Set Analysis in QlikView

Variable Set Analysis

Mon, 30 Jun 2014 14:38:40 GMT

I'm trying to pass a variable into my set analysis expression with no luck. This is what I'm going for:

Sum( '$(chatDate1)' [Sales])

Where my variable chatDate1 is:

'{$<dateFinal={">=$(=minDate)<$(=maxDate)"}>}'

I'm trying to keep this dynamic as I will eventually have many options that the user can select, so pasting this string into my expression doesn't seem like an efficient option.

My chart ends up not displaying any data, any suggestions?

Re: Variable Set Analysis

jaimeaguilar — Mon, 30 Jun 2014 14:47:54 GMT

Hi,

I think it may be that you're already including single quotes in the variable,

maybe like this:

Sum( $(chatDate1) [Sales])

it will underline everything after the name of the variable, however it is just a bug of the sintax checker and it should work as expected,

regards

Re: Variable Set Analysis

Mon, 30 Jun 2014 14:52:00 GMT

Nope, it still doesn't show any data

It doesn't work if I do this either:

Sum( chatDate1 [Sales])

Without the dollar sign expansion... I honestly have no idea what I could do differently.

Re: Variable Set Analysis

Anonymous — Mon, 30 Jun 2014 14:53:19 GMT

in addition to Jaime's reply, the outer quotes in your variable expression are not necessary and you may have just included them in the post. so you don't need the single quotes in both the expressions.

Re: Variable Set Analysis

Mon, 30 Jun 2014 15:00:20 GMT

Thanks, that fixed it. I thought I had tried all possible combinations of using quotes, dollar sign expansion, etc... but I guess I missed one

Re: Variable Set Analysis

Anonymous — Mon, 30 Jun 2014 17:16:14 GMT

no problem...been there