How to Check same record in the current selected month is exist in the next month ?

[#1]

Hi,

I am new to qlikview.

I have below issues and questions.

if select current month and all the records in that month,

how can we know that, each record are exist in the next month or not ?

below is the example.

Month         Product

Jan-2014       ABC

Jan-2014       DEF

Feb-2014       ABC

Feb-2014       DEF

Mar-2014       ABC

Mar-2014       DEF

Apr-2014        DEF

let say,

we have Month in the selection box and we have Product in the table box or straight table.

let say,

we are selecting Jan-2014 then, next month is Feb-2014 and

it would show like below.

Product     Exist in the Next Month ?

ABC                        Yes

DEF                         Yes

let say,

we are selecting Mar-2014 then, next month is Apr-2014 and

it would show like below.

Product     Exist in the Next Month ?

ABC                        No

DEF                         Yes

How can we implement this ?

any thoughts ?

Any help would be appreciated.

Thanks!.

[kaushiknsolanki]

HI,

Have a look at the application attached.

Regards,

Kaushik Solanki

[#3]

Hi Kaushik,

I am seeing any attachment.

can you please attached that application again ?

Thanks!.

[kaushiknsolanki · Accepted solution]

Here it is.