Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Custom MonthYear range in a slider! How to do it ?

Hi,

I am looking to have a custom date range in a slider. I have a master calendar loaded and the start date is "01/01/2012" and the end date is "12/31/2014". I have around 20 tabs in my application and each tab has a slider with MonthYear of the Master Calendar as its dimension. So the span or MonthYear from start and end date is Jan 2012 to Dec 2014. All sliders diplay the range from Jan 2012 to Dec 2014. What i'm looking to acheive is I want some sliders range from Jan 2012 to Sept 2013, some from Jan 2013 to Dec 2013, i.e the MonthYear varies from slider to slider. How do i acheive it ? I tried to create variable and acheive it. But i'm not getting the right way to do it. Can someone help me out!

Regards,

Padmanabhan

1 Solution

Accepted Solutions
jagan
Partner
Partner

Hi,

PFA file for solution.

Regards,

Jagan.

View solution in original post

5 Replies
tresesco
MVP
MVP

Please post your sample app.

Not applicable
Author

Hi tresesco,

Pls find attached the sample app. Thanks for your help.

Not applicable
Author

Hi

use an expression instead of fieldname

something like  if(month >= 201201, month)

best regard

Chris

jagan
Partner
Partner

Hi,

PFA file for solution.

Regards,

Jagan.

tresesco
MVP
MVP


May be like attached sample. One suggestion, it's always better to create a MonthYear field in the script using MonthName() function than just a string concatenation.

PFA