topic Re: How to Check same record in the current selected month is exist in the next month ? in QlikView

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

Sun, 10 Aug 2014 15:23:53 GMT

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!.

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

kaushiknsolanki — Sun, 10 Aug 2014 15:36:12 GMT

HI,

Have a look at the application attached.

Regards,

Kaushik Solanki

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

Mon, 11 Aug 2014 02:52:42 GMT

Hi Kaushik,

I am seeing any attachment.

can you please attached that application again ?

Thanks!.

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

kaushiknsolanki — Wed, 13 Aug 2014 05:57:32 GMT

Here it is.