topic Re: Conditional Chart Expression Formatting based on Variable in QlikView

Conditional Chart Expression Formatting based on Variable

GeorgeQV — Sat, 16 Nov 2024 18:14:12 GMT

Dear all,

in the attached file, I show a chart with different KPI and values. Based on the KPI, the expression format should be in % or in absolute numbers. When the user select the KPI "Physical availability" or "Utilisation", it should be in percent. Otherwise in absolute numbers. I created a variable vExprFormat and use this in the bubble chart as dimension number format. However, it does not work. I could not find the solutions here to be useful for my case so I ask for advice.

Thank you for your effort and best regards,

Re: Conditional Chart Expression Formatting based on Variable

settu_periasamy — Wed, 12 Aug 2020 10:06:42 GMT

Hi ,

Try like

And, the number format settings should be 'Expression Default' (Number tab)

Re: Conditional Chart Expression Formatting based on Variable

GeorgeQV — Wed, 12 Aug 2020 10:23:27 GMT

Thanks, but I already tried exactly this. All the bubbles and their values disappear for some selected KPI. It's not working as it should be.

Note: The expression tab of the bubble chart is NOT the value that is displayed inside them. I had to use a little trick. The third dimension is the value that is displayed.

Regards,

Re: Conditional Chart Expression Formatting based on Variable

Brett_Bleess — Tue, 25 Aug 2020 16:31:29 GMT

I suspect you may be hitting a timing issue or something along those lines. I suspect the better solution would be to use a Button object to click to display each version of the chart that way you can use the actions to set things when the button is clicked, that should be much more reliable I believe.

Regards,
Brett