topic Change date format in Current Selection (for Quarters) in QlikView

Change date format in Current Selection (for Quarters)

NewbieToQV — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Newbie who have searched for an answer for 2 hours stuck here.

Can someone show me how to change the "Current Selection" from ">=01/01/2018" (highlight in yellow) to ">=Q1 2018"? Thks!

Re: Change date format in Current Selection (for Quarters)

marcus_sommer — Fri, 14 Jun 2019 11:04:35 GMT

I think it's not possible. But why not using a quarter-field instead of a date-field.

- Marcus

Re: Change date format in Current Selection (for Quarters)

NewbieToQV — Fri, 14 Jun 2019 13:04:56 GMT

What is a quarter-field and date-field?

Re: Change date format in Current Selection (for Quarters)

marcus_sommer — Fri, 14 Jun 2019 13:45:47 GMT

That's a date: 01/01/2018 and not a quartal like: num(201801, 'Q ######') - whereby your field must be numeric or at least dual if you want to apply operators like <=>.

Re: Change date format in Current Selection (for Quarters)

Brett_Bleess — Tue, 16 Jul 2019 21:34:51 GMT

Here is a Design Blob post that may be of some help in further grasping what Marcus was recommending I think:

https://community.qlik.com/t5/Qlik-Design-Blog/The-Master-Calendar/ba-p/1471527

There are tons of other posts out in this area of the Community as well, so try searching further there if the above does not really help you here, as there may be some other posts that will there. Just wanted to try to give you a little something further to maybe get you on the right track with things.

Regards,
Brett