Data Filter issue

[#1]

Hi Folks,

I need your help on data filtering.

I have sample document attached to the post.

my requirement is i have few fields like

CID---Contract ID

Csd-Contract Start Year

Ced-Contract end Year

Msd-Market Start Year

Med- Market end Year

Year-- calender year.

Now my requirement is i have to filter the date on basis of the start date and end dates.

condition is " The selected year has to return the Count(CID) value only if

Year is in between CSD and CED  also in between MSD and MED.

it has to satisfy both conditions.i.e 1)year has to be between CSD and CED 2)Year has to be between MSD and MED.

In my application if i select 2014 in Year field it has to display 1 as count in Table

if i select 2015 it should display 2 as Count.

Thanks,

Nani

[sujeetsingh]

Set analysis will resolve your issue .

QlikView App: Set Analysis - Prior Period Comparison

Date Comparison in Set Analysis

Compare Date with Variable Date in Set Analysis

[buzzy996]

hi,how you will get 2 this case,if u select 2015 it should display 2 as Count.? i think there is no sufficient data.

[#4]

Hi Shiva,

Thanks for your reply.

2015 should display count as 2, Because CID 2 & CID 4 satisfies my condition .

i.e 2015 if between Csd,Ced and Msd,Med.

Thanks,

Nani.

[Anonymous]

PFA,

2015 also has 1.

[buzzy996]

no,see below..howcome cid4 will sstisfies ur first condition(selected year should be in csd & cend

)

[#7]

Sorry shiva. I just realized my mistake.

You are correct.i hope you got my requirement

Thanks

Nani.

[buzzy996]

okie,can u correct ur .qvw file and share again?

[#9]

Hi Shiva,

Please find the updated app.