Variable is static in straight table?

Fri, 10 Mar 2017 18:30:05 GMT

I created a variable to use in a straight table expression. For some reason when I use it, the value doesn't change for each dimension value, but when I take the same thing that I set the variable to and put that in the expression in the table, the values do change based on the dimension. This is what the variable is set to:

=if(GetSelectedCount([Production Date]) <> 1, '-',

if(count([App Flag]) < 1, '-',

num((count(distinct if([App Flag] = 'Yes', [ID Number]))/count(distinct [ID Number])),'#,##0.00%')))

Is there anything I can do to make the variable act as a chart expression?

Thank you

Re: Variable is static in straight table?

sunny_talwar — Fri, 10 Mar 2017 18:34:29 GMT

When you define the variable in variable overview, remove the equal sign in front of the expression

The Little Equals Sign

topic Re: Variable is static in straight table? in QlikView

Variable is static in straight table?

Re: Variable is static in straight table?