topic Re: Scenario Help in QlikView

Scenario Help

abhaysingh — Tue, 07 Jul 2015 09:58:41 GMT

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

Re: Scenario Help

sunny_talwar — Tue, 07 Jul 2015 10:03:16 GMT

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

Re: Scenario Help

sunny_talwar — Tue, 07 Jul 2015 10:08:50 GMT

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))

));

Re: Scenario Help

abhaysingh — Tue, 07 Jul 2015 10:10:11 GMT

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??

Re: Scenario Help

sunny_talwar — Tue, 07 Jul 2015 10:14:34 GMT

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.