topic Re: Re: Re: Custom MonthYear range in a slider! How to do it ? in QlikView

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

Mon, 06 Jan 2014 06:59:29 GMT

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

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

tresB — Mon, 06 Jan 2014 07:25:50 GMT

Please post your sample app.

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

Mon, 06 Jan 2014 09:32:36 GMT

Hi tresesco,

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

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

Mon, 06 Jan 2014 09:59:44 GMT

use an expression instead of fieldname

something like if(month >= 201201, month)

best regard

Chris

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

jagan — Mon, 06 Jan 2014 10:04:03 GMT

Hi,

PFA file for solution.

Regards,

Jagan.

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

tresB — Mon, 06 Jan 2014 10:20:29 GMT

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