Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

variable confusion = or not

Hi,

I have a number of variables created which I reference in a pivot, in my expression that references the variables it shows blank unless I filter 1 record in the dimension used in the pivot and change the variable to have an = before it. 

I believe it is something to do with aggregation so in the variable I have then placed an aggr and aggregated it based on the dimension in question however this doesnt work.

can someone please help

2 Replies
Not applicable
Author

at least paste the chart expression

are the variables simply a value or they are calculated by expresion?

somenathroy
Creator III
Creator III

Hi,

You may define the variable without = sign before it. e.g sum(Filed1) / Sum(Fileld_2).  In chart expression use the variable as $(variable_name).

Regards,

Som