How to check if Record exist in Previous Month ?

[#1]

Hi all,

I am new to qlikview.

I have below questions.

let say,

we have records for every month.

Record    ReportMonth

    1             Jan - 2014

    1             Feb-2014

     1            Apr - 2014

Let say,

We have ReportMonth as List box as selection cirteria for user.

if user select

Report Month Apr - 2014 then

we can to check and display that record was exist in previous month or not.

so,

if they select

Apr - 2014, then we need to check for previous month Mar - 2014,

if it does not exist then need to show - 'N'

if it exist then need to show = 'Y'

how can check this ?

Thanks!.

[Anil_Babu_Samineni]

Hailey Desai wrote:

Manish,

How can i attach qv file here ?

I am not able to find any option where i can attach file.

Uploading a Sample