Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Set axis

Hi, I have a doubt in QlikSense

For example, I have some Sales for products each month. Later I need to filter by customer.

If I draw a graph in which the dimensions are months and Products, I'll see the correct chart because I have data in all months.

But if I filter by some customer that has data only in some months, The "X" axis is reduced and it shows only the months that have sales amount.

Set Axes.jpg

I want to set this axis and the chart shows every month whether or not they amount sales. If you do not have me show a 0 but it will be consider in the chart.


Thanks in advance


Regards

Tags (2)
1 Solution

Accepted Solutions

Re: Set axis

Try changing your expression by adding +sum({1}0) to it. The result will be that all months are always shown at the x-axis regardless of any selections.

2 Replies

Re: Set axis

Try changing your expression by adding +sum({1}0) to it. The result will be that all months are always shown at the x-axis regardless of any selections.

Not applicable

Re: Set axis

Thanks Gysbert!