Skip to main content
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Sam28
Contributor
Contributor

Qlik Calendar creation

Hi, 

I have a table with 3 columns (Items, Quantity, Date). I am trying to plot them into a bar chart to  find out the no sale months. when I plot them I see bars only for the months that are available in my date column. Is there a way that I can make the x-axis to show all the month of the and plot my data on top of that??

I see this:(example item wasn't sold in all the months, hence i see the below)

Sam28_0-1646779752914.png

and I want to see this:(this example item was sold every month)

Sam28_1-1646779800913.png

So when i chose an item in the filter despite the sale, I want the graph to show all the months in the x-axis and plot my data on top of that, which would help me identify no sale months easily. Could someone help?

Thank you so much in advance.

 

Labels (2)
1 Reply
Digvijay_Singh

Try adding  +Sum({1}0) at the end of your measure