Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Variable is static in straight table?

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

1 Solution

Accepted Solutions
sunny_talwar
Not applicable

Re: Variable is static in straight table?

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

The Little Equals Sign

1 Reply
sunny_talwar
Not applicable

Re: Variable is static in straight table?

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

The Little Equals Sign