topic Re: 50 Date Columns as Filters in QlikView

50 Date Columns as Filters

manideep78 — Thu, 25 Mar 2021 19:28:07 GMT

Dear Community,

I have a situation where I need to display lot of Date Columns as filters. I have 50+ date columns actually.

I know it's overwhelming 😖 but that's my situation.

user want to see them individual date columns instead of on master calendar Type.

I'm here for suggestion what is the best way to display them in QlikView Dashboard.

FYI - Few columns are just dates and few are timestamps.

My proposal:

Listed all columns in a input drop down. provide range FROM and To Calendar objects.

user can select the date column needed from drop down and select range from FROM and TO Calendar Objects and then apply dates button.

I appreciate any good inputs.

Thanks in advance.

Re: 50 Date Columns as Filters

Or — Thu, 25 Mar 2021 19:49:19 GMT

If your user wants to see them as individual date columns, your proposed approach doesn't do that at all - near as I can tell you're just suggesting a master calendar, which you said isn't an option.

To be perfectly honest, I'd suggest your user get acquainted with the Selections screen, where they can filter on any of the 50 dates in question. I can't think of a good way to show 50 (or even 10) calendars on one screen that also displays actual content, without using some variant of a master calendar.

Re: 50 Date Columns as Filters

manideep78 — Thu, 25 Mar 2021 19:56:54 GMT

Hi @Or ,

thanks for the quick response,

My idea is at least user will know what date column he/she selected or can see all column names displayed irrespective of what's happening in the background.

Re: 50 Date Columns as Filters

Or — Thu, 25 Mar 2021 20:03:26 GMT

I don't really understand how that's not using a master calendar... you're using one calendar to make selections over multiple fields (and only allowing selections on one at a time, which in itself can be a problematic limitation, no idea if that's the case for you here) and the actual selections will presumably be applied within the expressions (unless you plan to use a button to transfer the to/from into the actual field, but even then, this is still a master calendar).

If your user is OK with this master calendar approach, by all means go for it. It's better than trying to fit 50 filters on one screen for sure.