topic Re: Variable in Set Analysis in QlikView

Variable in Set Analysis

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi experts!

I am trying to define a variable that will be used in several expressions. This variable has a set analysis in it which also has a variable inside. It is like this:

vTarget_level = if(GetPossibleCount(TRG_GEO_LEVEL)=1, TRG_GEO_LEVEL={'RG'},TRG_GEO_LEVEL={'SR'});

vTargetCSAT_TablChart= sum({<TRG_CODE={'CSAT'}, $(=vTarget_level)>} TRG_TARGET * TRG_Target_Weights)/sum({<TRG_CODE={'CSAT'},$(=vTarget_level)>}TRG_Target_Weights)

I use it on a text object as:

=$(vTargetCSAT_TablChart)

What gives error. If i put in the text box:

=(vTargetCSAT_TablChart)

Results: sum({<TRG_CODE={'CSAT'},>} TRG_TARGET * TRG_Target_Weights)/sum({<TRG_CODE={'CSAT'},>}TRG_Target_Weights)

How should I do it so it gives the result?? Thanks.

Re: Variable in Set Analysis

YoussefBelloum — Fri, 26 Jan 2018 16:43:10 GMT

Hi,

verify that you didn't put an '=' when declaring both variables.

and use this:

=$(vTargetCSAT_TablChart)

Re: Variable in Set Analysis

Anonymous — Fri, 26 Jan 2018 16:57:30 GMT

There is no '=' in the declaration. They are both like this

Re: Variable in Set Analysis

YoussefBelloum — Fri, 26 Jan 2018 17:06:32 GMT

Actually i didn't read the content of the variables and the association between them.

did you try your first variable before ? the output should be a string

Re: Variable in Set Analysis

pradosh_thakur — Fri, 26 Jan 2018 18:13:25 GMT

try this

vTarget_level= if(GetPossibleCount(TRG_GEO_LEVEL)=1, 'TRG_GEO_LEVEL={'RG'}','TRG_GEO_LEVEL={'SR'}');

not put it in a text box and check