topic Re: Set analysis in a variable, with dynamic field value in another variable in QlikView

Set analysis in a variable, with dynamic field value in another variable

j_nlucas — Fri, 28 Apr 2017 17:37:04 GMT

Hello,

I have an expression with Set Analysis, that's configured in a variable as follows:

vSA_Cond1 = [Snapshot Type] = {'Current','History','Year to Dec 2016/17'}; (No quotes) :

Sum({<vSA_Cond1>}amount) This works just fine.

The problem now is to make the third value dynamic: 'Year to Dec 2016/17'

I have a second variable:

vYearToDec = 'Year to Dec $(vEntryYear_Previous)' (Quotes) --> This will return exactly Year to Dec 2016/17

Where vEntryYear_Previous = 2016/17 (calculated in the script)

This configuration is not working. It doesn't recognise the value in vYearToDec.

Any ideas?

Thank you

Joaquin

Anonymous — Fri, 28 Apr 2017 17:56:57 GMT

you could try a variable with parameters...

j_nlucas — Tue, 02 May 2017 07:43:33 GMT

Hello Robin,

Thank you for your suggestion. It's a good thing to have in the tool box definitely.

My approach is quite similar, since instead of using a parameter ($1) I was using a different variable. But the idea is the same.

I have fixed the problem by simply adding chr(39) before and after the variable vYearToDec, and that made the trick!

Joaquin