topic Re: Creating a date drop down filter using a Chart in QlikView

Creating a date drop down filter using a Chart

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

Hi Team,

I'm trying to create a Year,Month and Quater filter using a drop down option in a pivot chart.

When I tired to populate the selected year it is giving the selection but when I opt for clear option then it is replaced by '-' .

Can some one help me to identify the way to replace the '- ' with any default year when you click clear.

Also for Month when nothing is selected then it showing '-'.

Please find the source data and qvw.

Thanks In advance.

Re: Creating a date drop down filter using a Chart

tresB — Thu, 01 Feb 2018 10:05:31 GMT

May be using label expression like this?

Re: Creating a date drop down filter using a Chart

bohravanraj — Thu, 01 Feb 2018 10:08:16 GMT

Hi Vijaya,

You can use getselectedcount().

for E.g. : If(getselectedCount(Year) = 0,Max(Year),Year).

Check if its work for u.

-Vanraj Dinesh Bohra

Re: Creating a date drop down filter using a Chart

kvr9 — Thu, 01 Feb 2018 10:41:40 GMT

Hi ,

Thank you for your quick response,both the way worked for the Year.

But its not reflecting for month.can you please help me out

Re: Creating a date drop down filter using a Chart

tresB — Thu, 01 Feb 2018 10:49:22 GMT

Since your month field is a text field, max() would not work directly. Try label expression like:

=Month(max(Date#(Month,'MMM')))

Re: Creating a date drop down filter using a Chart

kvr9 — Thu, 01 Feb 2018 12:03:54 GMT

Hi Tresesco,

Thank you.

But the output was showing only one month in display (i.e max month is shown),I think user might be confused if it is showing only month,Can we have any default value if nothing has been selected

Re: Creating a date drop down filter using a Chart

kvr9 — Thu, 01 Feb 2018 12:07:39 GMT

It would be great help if you let me know for quarter as well

Re: Creating a date drop down filter using a Chart

tresB — Thu, 01 Feb 2018 12:07:48 GMT

I don't understand. You have separate fields for month, year and quarter and you want them to be available like in a drop down using straight table. Could you explain a bit more? May be explain with an example.

Re: Creating a date drop down filter using a Chart

kvr9 — Thu, 01 Feb 2018 12:30:23 GMT

Please find attached qvw