Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
GrantBooth
Creator
Creator

Show full date range in chart

I'm trying to create a chart that shows the full date range rather than a selected month.

In my chart I have the field Month, which are values from 01 to 12. When an individual month is selected, it shows the value just for that month, which is expected. What I am trying to do is have the full date range 01 to 12 appear.

The dimension  is =Month, and the value in the chart is sum(Amount)

I've tried using =Month={">=$(01)<=$(12)"} in the dimension and it's telling me it is an invalid dimension, any ideas?

3 Solutions

Accepted Solutions
AshutoshBhumkar
Partner - Specialist
Partner - Specialist

Hello,

You can ignore selection of Month on that chart if you dont want Month selection to affect your sales values.

E.g

Sum({<Month =, Year = {CurrentYear}>}Sales)

 

Thanks,

Ashutosh

View solution in original post

AshutoshBhumkar
Partner - Specialist
Partner - Specialist

Hi @GrantBooth ,

If I understood correctly, please check below example and correct me if I am wrong.

 

AshutoshBhumkar_0-1633494373455.png

As expected, I am displaying all of the 12 months regardless of the months selected.

 

View solution in original post

AshutoshBhumkar
Partner - Specialist
Partner - Specialist

Hello @GrantBooth ,

Please mark the answer as correct if that solves your problem. 🙂

Thanks,

Ashutosh

View solution in original post

6 Replies
AshutoshBhumkar
Partner - Specialist
Partner - Specialist

Hello,

You can ignore selection of Month on that chart if you dont want Month selection to affect your sales values.

E.g

Sum({<Month =, Year = {CurrentYear}>}Sales)

 

Thanks,

Ashutosh

GrantBooth
Creator
Creator
Author

Thanks for the response, I feel I may not have explained myself well enough. I am trying to display all of the 12 months regardless of the month that has currently been selected. 

AshutoshBhumkar
Partner - Specialist
Partner - Specialist

Hi @GrantBooth ,

If I understood correctly, please check below example and correct me if I am wrong.

 

AshutoshBhumkar_0-1633494373455.png

As expected, I am displaying all of the 12 months regardless of the months selected.

 

GrantBooth
Creator
Creator
Author

I stand corrected, that's exactly right, thanks heaps

AshutoshBhumkar
Partner - Specialist
Partner - Specialist

🙂

Hope that solves your query.

 

 

Thanks,
Ashutosh

AshutoshBhumkar
Partner - Specialist
Partner - Specialist

Hello @GrantBooth ,

Please mark the answer as correct if that solves your problem. 🙂

Thanks,

Ashutosh