topic Data Filtration 2 in QlikView

Data Filtration 2

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 -- date field should show data from 10-JAN-2017

2. When i select B in Region -- date field should show data from 17-DEC-2016

3. When i select C in Region -- date field should show data from 6-NOV-2016

if nothing is selected should show all data.

How to achieve this ?

buzzy996 — Wed, 15 Feb 2017 12:00:20 GMT

try tis way,

=Sum(If(Region ='A' and [Date]>='10/01/2017',[Sales Amount],

If(Region ='B' and [Date]>='17/12/2016',[Sales Amount],

If(Region ='C' and [Date]>='06/11/2016',[Sales Amount],

[Sales Amount]))))

hth

sasikanth — Wed, 15 Feb 2017 12:04:00 GMT

One way is

Create variables , vRegionA,vRegionB, vRegionC

Write Exp in List Object:

If(Region='A',Date_Field>$(vRegionA) ,

IF(Region='B',Date_Field>$(vRegionB) ,

IF(Region='B',Date_Field>$(vRegionC) ,Date_Field)))