topic Re: UI in Master calender in Water Cooler

UI in Master calender

niharika1234 — Fri, 14 Dec 2018 15:25:15 GMT

I have created Master Ca-lender for years , attached is screen shot. I want to see only years from 2013 to 2019 and don't want any scroll bar. Please suggest.

Thanks,

Niha

Re: UI in Master calender

rwunderlich — Fri, 14 Dec 2018 15:33:01 GMT

Can you create the calendar to have only years 2013 - 2019? Or do you need the extra years for some other purpose in your app?

-Rob

Re: UI in Master calender

Gysbert_Wassenaar — Fri, 14 Dec 2018 15:36:34 GMT

If you don't need the other years then don't load them.

Otherwise you could use an expression instead of the Year field for the listbox: aggr(Only({<Year={">=2013<=2019"}>}Year),Year). But perhaps creating an extra field in the load script and using that new field better suits your needs: If(Year>=2013 and Year<=2019,Year) as FilterYear.

Re: UI in Master calender

niharika1234 — Fri, 14 Dec 2018 16:43:09 GMT

Thanks all. The Year is default from 2013 to 2050. Since eventually it will go on increasing for user point of view I want to restrict only 5 or 6 years . Yes i will try your option. Thanks,

Niharika

Re: UI in Master calender

niharika1234 — Fri, 14 Dec 2018 16:44:24 GMT

Thanks.

It is better to have the year for future. But for user point of view 6 to 7 years are fine.

Thanks,

Niharika

Re: UI in Master calender

rwunderlich — Fri, 14 Dec 2018 18:54:05 GMT

It's generally a best practice to generate your calendar dynamically and create only the dates you need. It makes your UI much simpler.

You can generate the calendar completely at each script run limiting it to something like today(). Or you can load from a pregenerated calendar (like in a QVD) and filter as you load. Something like:

Calendar:
LOAD *
FROM calendar.qvd (qvd)
Where date <= today(1);

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Re: UI in Master calender

niharika1234 — Fri, 14 Dec 2018 18:54:23 GMT

Hello,

True From Extract layer I filtered the data between 2014 and 2022 and that worked.

thanks

Re: UI in Master calender

niharika1234 — Fri, 14 Dec 2018 19:41:19 GMT

Thanks. a very good idea.