topic Re: Data Filteration in QlikView

Data Filteration

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

Hi,

I have 2 fields Region & Date and a few charts

Region

--------

Date field is having data from JUNE-2016 to FEB-2017

My requirement is that,

1. When i select A in Region -- all charts&date fields should show data from only JAN-2017

2. When i select B in Region -- all charts&date fields should show data from only DEC-2016

3. When i select C in Region -- all charts&date fields should show data from only NOV-2016

if nothing is selected should show all data.

How to achieve this ?

Re: Data Filteration

kamielrajaram — Tue, 14 Feb 2017 10:10:25 GMT

Hi Mohan,

Hope this helps.

Kind Regards

Kamiel

Re: Data Filteration

mohan2391 — Tue, 14 Feb 2017 10:19:18 GMT

When i'm selecting A,B,C in your example, it is showing data for only Jan-17, Dec-16,Nov-16.

But i need to see data FROM Jan-17, FROM Dec-16, FROM Nov-16 depend on selection

Ex: If I select C, i should see data for Nov-16, Dec-16, Jan-17 & Feb-17 as well..

Re: Data Filteration

vardhancse — Tue, 14 Feb 2017 10:21:48 GMT

Hi,

It depends on the data what you are loading into the dashboard.

For specific region you need to have the specified month only data.

Re: Data Filteration

kamielrajaram — Tue, 14 Feb 2017 12:06:31 GMT

Hi,

Change the expression to

=if(GetSelectedCount(Region) =0, Sum(Quantity),

Sum({<CalendarMonthStart = {'>=$(vPreviousMonth)'}>} Quantity))

Re: Data Filteration

mohan2391 — Tue, 14 Feb 2017 12:47:55 GMT

It's working good.

If suppose u have a week field in that along with month and showing data week wise in charts.

How will you restrict it same like month ?

Re: Data Filteration

kamielrajaram — Tue, 14 Feb 2017 13:21:31 GMT

Hi Mohan,

Adding in another dimension should not affect the months displayed.

Kind Regards

Kamiel

Re: Data Filteration

mohan2391 — Tue, 14 Feb 2017 16:50:56 GMT

No, instead of having Month as dimension i want to use Week as dimension.

Dim : Week

Exp : Same as earlier

How to restrict on week depend on Region same as earlier

Re: Data Filteration

kamielrajaram — Tue, 14 Feb 2017 17:16:46 GMT