topic Re: Show only dimension value in Chart in QlikView

Show only dimension value in Chart

Wed, 25 Nov 2020 16:16:04 GMT

Hello all,

Underneath the image , you see a chart with dimension StoreCode and Month. In the chart Average orders amount

i only want to show the used expression for only the storecode WSDP and WSBK. in the image below you see irrelevant stores....

How can i fix this? Thanks!

Greets,

Rega

Re: Show only dimension value in Chart

sunny_talwar — Fri, 08 Apr 2016 14:53:53 GMT

May be use a calculated dimension here:

If(Match(StoreCode, 'WSDP', 'WSBK'), StoreCode)

and select 'Suppress When Value Is Null' on the dimensions tab

Re: Show only dimension value in Chart

sunny_talwar — Fri, 08 Apr 2016 14:55:16 GMT

Alternatively you can also use a set analysis in your expression. For example your expression was Sum(Sales), then change it to -> Sum({<StoreCode = {'WSDP', 'WSBK'}>} Sales)

I would suggest this approach, unless there is a very specific reason to use calculated dimension.

Re: Show only dimension value in Chart

Fri, 08 Apr 2016 15:05:50 GMT

Hey Sunny T,

How can i let the chart show "0" or zero sales ( for example some stores had €0 sales) but still i want to show this in a chart.

Which parameters /settings should i do?

Re: Show only dimension value in Chart

sunny_talwar — Fri, 08 Apr 2016 15:07:06 GMT

On the presentation tab -> uncheck 'Suppress Zero Values'