Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show only dimension value in Chart

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

1 Solution

Accepted Solutions
sunny_talwar

May be use a calculated dimension here:

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

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

View solution in original post

4 Replies
sunny_talwar

May be use a calculated dimension here:

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

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

View solution in original post

sunny_talwar

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.

Not applicable
Author

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?

sunny_talwar

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