Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

homersimpson
Contributor II

Questions about dimension and date

Hi,

i want to show always each month on the x-scale, no matter wich filter. How can i do that?

You see in the attachment are not all 12 month, may and dec are missing.

And the month are not correctly sort. Why? How can i change it?

Can you help me? Or have somebody an example app?

Regards,

Fritz

I added an example. If i filter for example for "Computer" there are no each month. And the month are not sort correct. Regards, Fritz

7 Replies

Re: Questions about dimension and date

Would you be able to share a sample. I believe it would be easier to help you that ways

MVP
MVP

Re: Questions about dimension and date

Your month values should be dual values, so you can sort the dimension values by numeric value.

Data Types in QlikView

Currently, it seems you sort by y-value descending. Go to sort tab and change the sort order.

To show all months no matter what values you have filtered, try something like

=Sum(Value) + Sum({1} 0 )

as expression, and disable 'Suppress zero values' on presentation tab.

reddys310
Honored Contributor II

Re: Questions about dimension and date

Hi Fritz,

you can achieve all the problems you are facing either by adding expressions or by changing properties in the properties panel.

It would be easier to solve and suggest you what to do if you can attach a sample qvf file.

Thanks and Regards,

Sangram Reddy.

Re: Questions about dimension and date

Try with sorting expression of =Only({1} Month)

Capture.PNG

homersimpson
Contributor II

Re: Questions about dimension and date

Thank you. I made this and it runs.

2016-01-20_11h01_26.jpg

homersimpson
Contributor II

Re: Questions about dimension and date

Hi,

i have found a solution (see attachment). But i think there is an easier way.

My next question is, how can i add the month in a second line? See screenshot.


2016-01-20_14h45_13.jpg

Regards,

Fritz

homersimpson
Contributor II

Re: Questions about dimension and date

I have found a solution:

2016-01-20_15h25_25.jpg

2016-01-20_15h26_42.jpg

Regards,

Fritz

Community Browser