topic Slider/Calendar Object min/max value in QlikView

Slider/Calendar Object min/max value

Thu, 21 Jan 2010 13:41:01 GMT

Hello,

I am confronting with a situation regarding a calendar object.

I need to do a sales report about periods of sales , using 2 variables :FromDate and UntilDate, which i created on Settings-Variable Overview-Add. For The calendar objects i didn't set a min value or a max value(this boxes are blank).

In Settings-Document Properties- Variables there is no special settings(is standard).

For 2009 is ok, because when i want to chose year it is a mini menu where i could chose from year 2000 to year 2009(i think there is somewhere a setting to get just an interval of 10 years).

Now we are in 2010, i have sales also in 2010 but i can't use calendar object to see also this period of sales.

Thank you very much in advance.

Please HELP.

Onix.

Slider/Calendar Object min/max value

Thu, 21 Jan 2010 14:41:22 GMT

Hi Onix,

why don't you set the min value of the calendar object to min(YourYearVariable) and the max value to max(YourYearVariable) ?

regards,

Walter.

Slider/Calendar Object min/max value

Thu, 21 Jan 2010 15:07:26 GMT

Thank you very much!

I've tried your solution and it works.

Slider/Calendar Object min/max value

Mon, 30 Aug 2010 19:36:37 GMT

Hi,

I have scenario like this, there is list of dates from data file. I have to look at minimum Year value and maximum Year value. Lets say there is ten records from data file. the first date falls on 21-03-2002 and the last recored(10th) falls on 31-10-2010. I want the values in the list box is From Mar-2002,Apr-2002,May-2002... to Sep-2010,Oct 2010.

Appreciate your response. Thanks.

also can you please post the solution code

Slider/Calendar Object min/max value

Mon, 30 Aug 2010 19:49:17 GMT

You can do on your script, you can set a variables with min and max....

Something like this

Load min(var_data) as var_min_date from XYZ;

Load max(var_data) as var_max_date from XYZ;

set min_date = MONTHNAME(var_min_date)

set max_date = MONTHNAME(var_max_date)

And set max and min values in your object!!!!

Slider/Calendar Object min/max value

montubhardwaj — Mon, 30 Aug 2010 20:53:43 GMT

you can create the variables like this: (in settings-->Variables)

min_date=min(date)

max_date=max(date)

And then you can set in your object something like this:

date(min_date,'MMM-YY')

and date(max_date,'MMM-YY')

Hope it was helpful.

Cheers,

Sharma

Slider/Calendar Object min/max value

Wed, 01 Sep 2010 05:12:49 GMT

Thanks for quick response. This works in the way of Jan-2010.

Appreciate your response. Thanks Again.