count the repeated ones and add their values

[Anonymous]

I have 201401 that has N documents and N values, I have 201402 that has some documents equal to 201401 and some values of the same 201401 and I have 201403 that has some documents equal to 201401 and some values of 201401 same,

I want:

Select 201401 and tell me that the same documents have 201402 and 201403, which values also have the same in 201402 and 201403 and that counts the documents and that the values go up

Thank you

[wdchristensen]

Can you post an example spreadsheet containing the data?

[Anonymous]

[wdchristensen]

You can make a new field called quarter:

if(len(DATE)>0, 'Q' & ceil(month(DATE)/3))

and use that as your filter.

[Anonymous]

but I need to find and count the same records month by month

[MarcoWedel]

please post some sample data as file/text (not as image) and your expected result

thanks

regards

Marco

[Anonymous]

The documents in https://mega.nz/#!PZElDIRT!7u1v4ZbioJ9hrAu2_ewksJ-iR0gpDdq4WXtqL1DNDFI

I need you to compare only 201401 with the other two and count each time you find an equal one, plus add the amounts you find also the same, in the background is to find the same cam of 201401 in 201402 201403 and show me the number of records equal and the result of the sum of the equal amount values

if you need more information please talk to me for whatsapp +56932915440 thnxs

[Anonymous]

https://mega.nz/#!PZElDIRT

[MarcoWedel]

please post some sample data as file/text (not as image) and your expected result.

maybe helpful:

Uploading a Sample

Qlik Community Tip: Posting Successful Discussion Threads

Preparing examples for Upload - Reduction and Data Scrambling

Qlik Community Tip: How to Get Answers to Your Post

thanks

regards

Marco

[Anonymous]

marcowedel‌

the result of the results results is theoretical because I do not know how you do what I said.

I need you to tell me that 201401 Documents are in 201402 and that sums up their amounts, likewise 201401 vs 201403

Thank you very much