topic Re: Conditional Expressions on a Chart in QlikView

Conditional Expressions on a Chart

Eureka99 — Wed, 02 Oct 2019 12:17:35 GMT

Hi,

I have a visualisation that charts month by month sales for the company, split into 7 sales areas.

Above is the chart and below my expression

I have had a request to add the sales areas as selectable fields to the tab, and then have the sales areas appear on the chart as and when they are selected. The selectable fields is simple, but how would I tie the individual expressions to the selectable field?

Re: Conditional Expressions on a Chart

Eureka99 — Wed, 02 Oct 2019 12:18:12 GMT

As a note, I have only given one expression, I have one for each of the 7 sales areas.

Re: Conditional Expressions on a Chart

sunny_talwar — Wed, 02 Oct 2019 12:40:58 GMT

Is Holon the field which is related to sales areas?

Re: Conditional Expressions on a Chart

Eureka99 — Wed, 02 Oct 2019 12:52:24 GMT

Yes, Holon is the field for the sales areas

Re: Conditional Expressions on a Chart

sunny_talwar — Wed, 02 Oct 2019 13:03:05 GMT

May be use this expression

Sum({YTD<Holon *= {'AA'}>} UANTAM)/1000

Re: Conditional Expressions on a Chart

Eureka99 — Wed, 02 Oct 2019 13:55:38 GMT

Hi SUnny,

This didnt work.

I've managed to work around it by setting a load of Variables in my load for that are like vAA and set them to 0.

I've then placed a button to set the variable to 1 and use the conditional statment on the expression to show when vAA = 1