I am new to QlikView.
My datas are in vector format. e.g. :
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.
May be these options
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'))
Your original post looks like same which we thinking. Any how, Can you describe more exactly what are you trying to achieve
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')) )