topic Re: Dynamically filtering data based on selections in QlikView

Dynamically filtering data based on selections

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I had a question: Can I filter data in QV dynamically like this: When I select 2 months say Jan , Feb, data should get filtered to give me latest date for each store.Then I want to calculate all my charts exoressions based on this filtered data.Is this possible?

Sample Data:

Month Qtr Date Store

Jan Q1 1/1/2014 A

Feb Q1 1/2/2014 A

Mar Q1 1/3/2014 A

Jan Q1 1/1/2014 B

Feb Q1 1/2/2014 B

Mar Q1 1/3/2014 B

When I select Jan, Feb in QV, Data should become:

Month Qtr Date Store

Feb Q1 1/2/2014 A

Feb Q1 1/2/2014 B

And all Charts in my QV app should use above data to calculate expressions.

Please help out!Thanks in advance!

Re: Dynamically filtering data based on selections

Anonymous — Wed, 12 Oct 2016 20:21:03 GMT

hi try this

Only({$<[MonthYear]={"$(=Date(Max(MonthYear), 'MMM-YYYY'))"}, Date={"$(=date(max(date),'DD/MM/YYYY'))">} store )

Re: Dynamically filtering data based on selections

Thu, 13 Oct 2016 06:38:08 GMT

Hi Allu,

Thanks so much for your reply.But maybe I should explain my requirement more clearly.I need to do calculations in charts based on the filtered data.So for example:

When I click Q3 in filter, data should filter such that each Store No. should have only latest sale date.Then in the pivot table it should sum the sales only for these latest sale dates.Similarly, sum(sales) for a store should sum sales for only those store No.s with latest dates as for a period selected() MonthYear/Qtr/2 visit Dates/2 Months). This should apply for any period filter: Quarter, MonthYear, Date.

I have attached QVW for reference.

In Screenshot: it currently adds sales for all dates of Store No 1 in Q3.I would need only latest Date of Store no 1 in Q3.

Hope this made sense! Thanks for your help!Hope this is possible in Qlikview?