Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
lanlizgu
Creator III
Creator III

Month Range Picker

Instead of having the data at date level, I have data at month level. I was wondering if there is a way to have a month range picker, instead of the date range picker.

 

Thank you

Labels (3)
4 Replies
Ezir
Creator II
Creator II

Hi @lanlizgu ,

 

In script you could do:

Date(MonthStart(floor(DATE)),'MM/YYYY') AS MONTH_REFERENCE

 

In dashboard you could do:

1-datepicker.png2-dash.png2-FieldMonth.png

 

I hope helps.

lanlizgu
Creator III
Creator III
Author

Hi,

 

Thank you for your answer Exir. However, I already have the date in MM/YYYY format.

As I was mentioning before, I want to have a month range picker and not date range picker. With your suggestion it continues being date range picker and not month range picker.

 

Thank you.

Ezir
Creator II
Creator II

Hello @lanlizgu !

A suggestion...

1) You can create two variable input (https://help.qlik.com/en-US/sense/June2019/Subsystems/Hub/Content/Sense_Hub/Visualizations/Dashboard...vStart and vEnd

2)If I enter 6 in vStart input box and 12 in vEnd input box... I should get between 6-12

3) You can use a calculated dimension: 

if(Month>=$(vStart ) and Month<=$(vEnd), DIMENSION)

lanlizgu
Creator III
Creator III
Author

Hi Ezir,

 

Thanks for your suggestion. However, the solution that I am looking for is something like that:

Captura.JPG