topic Re: Variable is not working in Set Analysis in QlikView

Variable is not working in Set Analysis

Fri, 15 May 2015 12:10:40 GMT

Hey,

can anyone help me. I create a set analysis function with a variable vTest inside. But this function1 doesn´t work. I want to choose in Objekt A or B and then the function should give me the value of Wert like in Function2...

Thank you

Re: Variable is not working in Set Analysis

sunny_talwar — Fri, 15 May 2015 12:14:31 GMT

Have a look, its working.

Need to add '=' to your variable and use this expression:

=sum( {$<Objekt = {"$(vTest)"}>} Wert)

Re: Variable is not working in Set Analysis

maxgro — Fri, 15 May 2015 12:15:17 GMT

try vTest (remember 😃

=concat(distinct chr(39) & Objekt & chr(39), ',')

Re: Variable is not working in Set Analysis

Gabriel — Fri, 15 May 2015 12:19:39 GMT

Hi,

The content of your variable needs = sign.

So in the variable overview window click on your variable and in the definition section enter = before the fieldname