This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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.
Hi @lanlizgu ,
In script you could do:
Date(MonthStart(floor(DATE)),'MM/YYYY') AS MONTH_REFERENCE
In dashboard you could do:
I hope helps.
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.
Hello @lanlizgu !
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)
Thanks for your suggestion. However, the solution that I am looking for is something like that: