Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

How to always display all values in a dimension ?

Hello,

I am new to QlikView.

My datas are in vector format. e.g. :

typequantitymonth
apple200march
orange30march
apple90may
apple30april

My bar chart is quantity(month) with a 'type' filter outside of it. The expression of my chart is "sum(quantity)".

I want the bar chart to always display all values avaiable in a dimension even if there is no vector corresponding. e.g. : If the filter is set on 'orange', i want the bar chart to display : march : 30 / may : 0 / april : 0 and not : only one bar corresponding to march with 30 quantity value...

I have tried 'Dimensions\Settings for Selected Dimension\Show All Values', it doesn't work. And Presentation\Suppress Zero-Values is uncheck.

Regards,

Tags (2)
8 Replies

Re: How to always display all values in a dimension ?

Like this?

Capture.PNG

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

Re: How to always display all values in a dimension ?

May be these options


Presentation Tab

Capture.PNG        

Dimension Tab

Capture.PNG

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
qlikviewnovice
Valued Contributor II

Re: How to always display all values in a dimension ?

Hi

Have a look

Hope it helps!!

qlikviewnovice
Valued Contributor II

Re: How to always display all values in a dimension ?

Maybe like this

Not applicable

Re: How to always display all values in a dimension ?

anilkumar.btloveisfail

Hey thanks for helping. It doesn't work with my set of data...

Not applicable

Re: How to always display all values in a dimension ?

Basically, I want QlikView to be able to create a time dimension by month that won't be affected by filters. In my set of data, the month time dimension cannot be sorted despite my sorting expression : MonthName(Date#(Month, 'MMM-YY'))

Re: How to always display all values in a dimension ?

Your original post looks like same which we thinking. Any how, Can you describe more exactly what are you trying to achieve

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Not applicable

Re: How to always display all values in a dimension ?

Hi,

Here is my problem:

When no filter is selected, all months are displayed:

demand global qlik.PNG

When I select a filter:

sku selected qlik.PNG

sku filter qlik.PNG

How can I keep my time dimension constant over the selection ?

( the time dimension is sorted as follows : MonthName(Date#(Month, 'MMM-YY')) )

Regards,