topic Re: Drop down filter of quarter based on Month selection in QlikView

Drop down filter of quarter based on Month selection

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

Hi ,

I have an issue with populating the date filter i.e Month and Quarter.

I want it to be in drop down format(Used Pivot chart).

I want to give the default as Month when nothing is selected ,followed by Quarter.

Please find the attached example.

Re: Drop down filter of quarter based on Month selection

jaumecf23 — Tue, 06 Feb 2018 09:45:15 GMT

In the dimension name you can use something like that :

=if(GetSelectedCount(Quarter)=0,'Quarter',MaxString(Quarter))

The Quarter value will be visible if a Quarter has been selected.

Re: Drop down filter of quarter based on Month selection

kvr9 — Wed, 07 Feb 2018 10:25:54 GMT

Hi,

I want quarter to reflect when the month is selected, with your query quarter has been populated when the quarter is selected.

Re: Drop down filter of quarter based on Month selection

jaumecf23 — Wed, 07 Feb 2018 12:19:15 GMT

Then you can add as formulas as fields you need to check. Something like that :

=if(GetSelectedCount(Quarter)=0 or GetSelectedCount(Month)=0,'Quarter',MaxString(Quarter))

Re: Drop down filter of quarter based on Month selection

kvr9 — Wed, 07 Feb 2018 13:08:45 GMT

Thank you Jaume, it worked but when I select multiple month /Quarter that should also reflect.

I tired using concat but its throwing an error

Re: Drop down filter of quarter based on Month selection

jaumecf23 — Wed, 07 Feb 2018 13:34:15 GMT

Sorry I did a mistake. Try this:

=if(GetSelectedCount(Quarter)=0 and GetSelectedCount(Month)=0,'Quarter',MaxString(Quarter))

Re: Drop down filter of quarter based on Month selection

kvr9 — Wed, 07 Feb 2018 13:36:57 GMT

Yes,I tired using 'AND' only

Re: Drop down filter of quarter based on Month selection

jaumecf23 — Wed, 07 Feb 2018 13:41:33 GMT

The result is not what you are expecting ? Can you attach and example of the behavour that you need.

Re: Drop down filter of quarter based on Month selection

kvr9 — Wed, 07 Feb 2018 13:52:17 GMT

I mean the Initial requirement has worked with your query.

I'm also looking for an additional requirement.

it worked for one selection but when I select multiple month /Quarter thae same should also reflect.

I tired using concat but its throwing an error

ex:Jan,Jun then Quater must be Q1,Q2

Re: Drop down filter of quarter based on Month selection

jaumecf23 — Wed, 07 Feb 2018 14:00:45 GMT

Maybe this : =if(GetSelectedCount(Quarter)=0 and GetSelectedCount(Month)=0,'Quarter',concat(DISTINCT Quarter,', '))

Re: Drop down filter of quarter based on Month selection

isingh30 — Wed, 07 Feb 2018 15:25:50 GMT

Please check this. Let me know.

Thanks.

Re: Drop down filter of quarter based on Month selection

kvr9 — Thu, 08 Feb 2018 12:06:05 GMT

Hi Jaume,

Many thanks that works as expected.

Can you please tell me the same output for Month filter.

Default should show Month upon selection of month/Quarter the respective should reflect(Including concat option)

Re: Drop down filter of quarter based on Month selection

kvr9 — Thu, 08 Feb 2018 12:08:25 GMT

Hi Ishtdeep,

Thank you for your response.

The pivot table works perfectly,but I'm looking for a filter option (I.e individual representation of Year,Month & Quarter)

Re: Drop down filter of quarter based on Month selection

isingh30 — Thu, 08 Feb 2018 14:36:39 GMT

Do you want to see one thing at a time in chart? You can do this in straight table with Cyclic group.

Thanks.