topic how to create calender like this?? in QlikView

how to create calender like this??

sushil353 — Thu, 22 Sep 2011 07:35:47 GMT

Hi All,

I want to create a object to select year,month and days.. I catch a example from a qlikiview dashboard example...

Please share your experience to get the similar result as shown below..

Thanks

Sushil

Re: how to create calender like this??

Thu, 22 Sep 2011 08:06:23 GMT

Hi sushil,

That is not a single object, in fact that is composed of 2 diffent objects: List box and Text Object. The key to this kind of presentation is 1. Layering. The object layer of the text object should be lower than the Layer of the list boxes so that it will appear as a background. 2. Remove the "Show Caption" of the List Boxes OR get the same color of the Text box and apply it on the list box caption (active, inactive and text). And that's it..

Regards,

Lester

how to create calender like this??

sushil353 — Thu, 22 Sep 2011 08:11:13 GMT

Thanks Buddy,

i agree with your suggestion..for year and month i am ok... but the problem is with date... how to restrict dates only from 1 to 31. In my data the day field contains all the dates related to every month..

Re: how to create calender like this??

Fri, 23 Sep 2011 04:52:51 GMT

sushil,

To get the Day on the date field, on your script:

day(Date) as Day,

Its just the same like getting the month or year..

Regards,

Lester