Scenario Help

[abhaysingh]

    Hey Every one,

i have One scenario, where i want

Suppose i have data of 1 Month and Currently i am in 2nd Month,

In 1 Month Suppose there are 10000 Record and in 2nd Month there are new 5000 record's with some backdate entries in it, suppose 500 record changes through back date entry...

Now i want to know which entries are changed through back date entries??

Can i show Comparison like

Tab1

Header 1	Header 2	Header 3
S.No	Field	Amount
1	ABC	12000
2	DEF	5000

Header 1	Header 2	Header 3
S.No	Field	Amount
1	ABC	10000
2	DEF	5000

Now i want comparison

Which can show me ABC amount 12000 has been changed to 10000 through BackDate Entry..

Thanks in advance..

[sunny_talwar]

If I understand your requirement, I think you should be able to flag the new entries (BackDated Entries) and then use that when you are trying to compare BackDate Entries vs. Regular Entries. Does that make sense?

Best,

Sunny

[sunny_talwar · Accepted solution]

Something like this may be?

Table:

LOAD @1 as S.No,

    @2 as Field,

    @3 as Amount,

    'Regular' as Type

FROM

[https://community.qlik.com/thread/171502]

(html, codepage is 1252, no labels, table is @1, filters(

Remove(Row, Pos(Top, 1)),

Remove(Row, Pos(Top, 1))

));

Concatenate(Table)

LOAD @1 as S.No,

    @2 as Field,

    @3 as Amount,

    'BackDated' as Type

FROM

[https://community.qlik.com/thread/171502]

(html, codepage is 1252, no labels, table is @2, filters(

Remove(Row, Pos(Top, 1)),

Remove(Row, Pos(Top, 1))

));

[abhaysingh]

till now i just concatinate 1Month Data and 2Month Data....and putted flag in it to bifurcate it..

But can you pls help me how i can give report like which entries(BackDated) are changed??

[sunny_talwar]

Use you flag field to differentiate between BackDated fields and regular fields. I am not sure what kind of report you are looking for here.