topic Re: Data Filter issue in QlikView

Data Filter issue

Wed, 24 Jun 2015 07:14:07 GMT

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

Re: Data Filter issue

sujeetsingh — Wed, 24 Jun 2015 08:25:27 GMT

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

Re: Data Filter issue

buzzy996 — Wed, 24 Jun 2015 08:27:22 GMT

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.

Re: Data Filter issue

Wed, 24 Jun 2015 08:33:41 GMT

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.

Re: Data Filter issue

Anonymous — Wed, 24 Jun 2015 08:49:48 GMT

PFA,

2015 also has 1.

Re: Data Filter issue

buzzy996 — Wed, 24 Jun 2015 08:58:05 GMT

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

)

Re: Data Filter issue

Wed, 24 Jun 2015 09:10:45 GMT

Sorry shiva. I just realized my mistake.

You are correct.i hope you got my requirement

Thanks

Nani.

Re: Data Filter issue

buzzy996 — Wed, 24 Jun 2015 09:14:27 GMT

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

Re: Data Filter issue

Wed, 24 Jun 2015 09:29:55 GMT

Hi Shiva,

Please find the updated app.