Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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