Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
shilpagupta1687
Contributor III
Contributor III

Can we create a slider to shown dimension like MonthYear?

Hi Friends,

I am wondering if anybody has an idea if we can create a slider showing MonthYear say '2022-Jan' as the values on the slider. As per my understanding we can only show some numerical values on the slider. Please advise me.

I want to show in a map how the sales is changing with the MOnthYear selected in the slider.

Thanks,

Shilpa

Labels (3)
2 Replies
vinieme12
Champion III
Champion III

Yes , as below

 

Calendar:
Load
Date
,rand() * 300 as Sales
,MonthYearIs
,Autonumber(MonthYearIs) as MonthNum
,pick(ceil(Rand()*4),'RUSSIA','INDIA','JAPAN','GERMANY') as Country
;
Load monthstart(date#('2010-01-01','YYYY-MM-DD'),iterno()-1) as Date
,Monthname(monthstart(date#('2010-01-01','YYYY-MM-DD'),iterno()-1)) as MonthYearIs
,month(monthstart(date#('2010-01-01','YYYY-MM-DD'),iterno()-1)) as MonthIs
Autogenerate 1
While monthstart(date#('2010-01-01','YYYY-MM-DD'),iterno()-1) <= date#('2022-01-01','YYYY-MM-DD')
;

 

 

Create a variable = vMonth  empty definition

Drag a Variable Input onto the sheet from Custom Objects >> Variable Input

 

Choose Variable = vMonth

min value = Min(MonthNum)

max value = Max(MonthNum)

Step =1

General Title for Slider = only({<MonthNum={"${vMonth}"}>}MonthYearIs)

 

In you Map chart

use expression =  Sum({<MonthNum={"$(vMonth)"}>}Sales)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
shilpagupta1687
Contributor III
Contributor III
Author

Hi Vineeth,

Thank you so much for your response.

Let me try and check this. I will keep you posted.

 

Regards,

Shilpa