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

[#2]

Thanks Manish.

I have Tested your above code in test qvd.

it is working fine in test file.

when i have kept your above logic in my real application,

it is partially working....

i am getting duplicates records...

do you know what could be issue ?????

thanks for your all help

[#3]

Please Any one Help here on above questions ?

PLEASE PLEASE PLEASE

[MK_QSL]

Kindly provide sample file or data where you are having duplicated records..

[#5]

Manish,

How can i attach qv file here ?

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

[MK_QSL]

Use Advanced Editor.... It is on the TOP RIGHT of your edit page...

[#7]

Manish,

I am not find edit page...

does it under Create Next to Link Tab ?

Under create i can see upload attachment option,

but, i am not sure, that upload over there will attach to this thread ???

thanks!.

[MK_QSL]

[#9]

Manish, this windows appear

,

when i have press Reply button to your response.

I can see above screen , but it does not have - Use Advance Editor option.

[MK_QSL]

Click on

How to check if Record exist in Previous Month ?

Now go to reply, you can see.

[jim_chan]

this is good!!!

how to show all the record of yes in a text box object???

Rgds

Jim