topic Variable in Chart Expression showing chart total instead of dimension total in QlikView

Variable in Chart Expression showing chart total instead of dimension total

Mon, 20 Mar 2017 13:26:18 GMT

I have created a variable to return the total number of opted in profiles, but when i use this variable in a chart, it's returning the total for the chart as the result for each dimension. When i put the same expression directly into the chart expression, it works fine, but when i use the variable, it doesn't. Can anyone tell me what i'm missing?

Here is the expression, i'm counting distinct profile IDs where they have an Opt In Flag = 1 but NOT Opt In Rem = 1 or OptOut Flag = 1:

=Count(DISTINCT {<OptIn_Flag = {1}, ProfileID = e( {<OptInRem_Flag = {1}>} ProfileID), ProfileID = e( {<OptOut_Flag = {1}>} ProfileID)>} ProfileID)

Re: Variable in Chart Expression showing chart total instead of dimension total

sunny_talwar — Mon, 20 Mar 2017 13:34:17 GMT

Remove the '=' sign in front of your variable definition and see if that helps?

The Little Equals Sign

Re: Variable in Chart Expression showing chart total instead of dimension total

CarlosAMonroy — Mon, 20 Mar 2017 13:37:45 GMT

Hi Ashley,

You have the = sign in your variable definition. You have to remove it and the variable will work fine.

Thanks,

Carlos M

Re: Variable in Chart Expression showing chart total instead of dimension total

jeevays7 — Mon, 20 Mar 2017 13:43:11 GMT

Hi,

try this.

copy and paste below expression in a variable (without "=" infront of the expression.)

Count(DISTINCT {$<OptIn_Flag = {1}, OptInRem_Flag -= {1}, OptOut_Flag -= {1}>} ProfileID)

then in chart expression write this.

=$(variablename) (i.e variabel name is your variable name)

Re: Variable in Chart Expression showing chart total instead of dimension total

Mon, 20 Mar 2017 15:41:45 GMT

Marking this one as complete because it includes the extra step to add the dollar sign expansion to the variable name in the expression. However, changing the syntax of the set analysis was not necessary - it still works the way I had it as long as i removed the = from the beginning.

Re: Variable in Chart Expression showing chart total instead of dimension total

jeevays7 — Tue, 21 Mar 2017 06:31:09 GMT

Yes,

your expression also correct. the main thing is "=" only.