topic Re: issue on calender object in QlikView

issue on calender object

Wed, 25 Nov 2020 16:16:04 GMT

i have created a calendar object to filter the data.in that how to show only possible values?

Thanks

Re: issue on calender object

johnw — Thu, 23 Jun 2016 20:15:46 GMT

So if you don't have data for May 2, for instance, you don't want May 2 to show in the calendar object? I assume you want this because it's really annoying clicking on a date and nothing happens because it's not a valid date.

I don't think it's possible to do it with the calendar object, unfortunately.

But if you want to go to enough trouble, you can create a fake calendar object that will give you full control over what is displayed and how. Attached is an example I made for someone a long time ago who wanted a calendar object that went Sunday to Saturday instead of Monday to Sunday. You might, for instance, go ahead and display all the days, but use the background color expression - white for possible with current selections, gray for not possible with current selections, maybe darker gray for doesn't exist in your data at all. Something like that.

Only worth the trouble if it's really, really important, I'd say.

Re: issue on calender object

Thu, 23 Jun 2016 20:30:32 GMT

i just want to display only associated data in my object.could you please suggest me on this

Thanks

Re: issue on calender object

marcus_sommer — Fri, 24 Jun 2016 06:50:18 GMT

Hi John,

there is a solution from staschereau for the calendar weekday-start topic: Calendar Object Start Day and maybe this way offers further possibilities to adjust the calendar.

- Marcus

Re: issue on calender object

PrashantSangle — Fri, 24 Jun 2016 07:15:48 GMT

Hi,

You can create your own calendar.

You can use List box having days (with some formatting on list box > Property> presentation) and present it as calendar instead of using calendar object.

Regards,

Re: issue on calender object

Fri, 24 Jun 2016 12:31:00 GMT

If you specify a min and max date in the Calendar Object, any dates outside that range are displayed as "grayed out". I think this is as close to what you're looking for as you can expect from the Calendar Object. Otherwise you will have to create your own.

Re: issue on calender object

Fri, 24 Jun 2016 14:30:06 GMT

Thanks for your Response ..guys

i have implemented like this and also works fine

=Aggr(Only({<List2>} List2), List2)

Re: issue on calender object

johnw — Fri, 24 Jun 2016 16:05:08 GMT

Interesting and scary! And yes, maybe there are other settings that can be tweaked. I'll file this under "last resort if your client is very, very insistent" or maybe "I wish I'd never seen this because now that I know about it I can't claim that it's impossible". That's been a problem in the past when I've been asked for things that I considered very ill-advised, because they just aren't "the QlikView way" of displaying your data. But can I do it? Grumble grumble grumble yes I can. One of the disadvantages of knowing things.

Mind you, my fake calendar is also very ill-advised. That's a whole lot of complexity, and newer QlikView versions broke it between when I built it and now. I had to fix it in order to post it. You don't want to have a new version of QlikView force you to edit all of your calendar objects in every application unless you absolutely must have something other than the default calendar.

But I generally don't use calendar objects. I use year, month year, and date fields. We're rarely interested in arbitrary date ranges. Arbitrary lists of months, yes, but that's easily selected with a month year field.

Re: issue on calender object

Fri, 24 Jun 2016 16:21:25 GMT

My clients want it all... arbitrary date ranges, weeks that start on Sunday, etc.. and they're very insistent. That's why my first response is always "Sorry, QlikView doesn't support what you're asking for" and my second response is "but I found a way to do it."