How to always display all values in a dimension ?

[#1]

Hello,

I am new to QlikView.

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

type	quantity	month
apple	200	march
orange	30	march
apple	90	may
apple	30	april

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,

[Anil_Babu_Samineni]

Like this?

[Anil_Babu_Samineni]

May be these options

Presentation Tab

        

Dimension Tab

[Anonymous]

Hi

Have a look

Hope it helps!!

[Anonymous]

Maybe like this

[#6]

anilkumar.bt‌ loveisfail‌

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

[#7]

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'))

[Anil_Babu_Samineni]

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

[#9]

Hi,

Here is my problem:

When no filter is selected, all months are displayed:

When I select a filter:

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

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

Regards,