Aggr in stack bar

karin_nevo — Wed, 25 Oct 2017 06:31:33 GMT

Hi,

I have list of metrics and their grade for different dimensions.

I need to determine the color of each metric by it's grade (each metric has different color scale)

since the grade changes based on dimension selections, I can't determine the color in the script, it has to be uppon user selection.

I created a stacked bar chart that will count the number of metrics for each grade.

I used aggr function in the chart which has poor performance (each selection can take up to 30 seconds), and I couldn't find another way to create the chart.

I attached a simple example (with no dimensions and minimum rows 😞

Each metric has Numerator, Denomionator, and it's grade is: Numerator\Denominator (for most metrics).

the forumula's are defined within the script, and I created a variable in the script for each metric to determine it's color.

Each metric has color scale: for example - metric 1 should be red if grade < 70, and Metric 2 should be red if grade is grade>30

Any idea of a better way to create the chart?

Thanks,

Karin

topic Aggr in stack bar in QlikView

Aggr in stack bar