topic Re: How to compare two similar data sets using a chart function ? in QlikView

How to compare two similar data sets using a chart function ?

Anonymous — Mon, 06 Aug 2018 13:43:09 GMT

Hi all!

I have two data sets 'X' and 'Y' which are of similar data type having same header fields.

Eg; Data set 'X' is old data and 'Y' is the current refreshed data

How can I bring up these two data sets in a same bar graph next to each other as shown in the below snap?

Shall I store the data in two separate files or shall I just append these two data sets in single file ?

Re: How to compare two similar data sets using a chart function ?

sunny_talwar — Mon, 06 Aug 2018 13:44:41 GMT

I think you should be able to append the two data sources, but may be add a flag to differentiate between old and new.... and then you can use this flag as one of the dimensions....

Re: How to compare two similar data sets using a chart function ?

Anonymous — Mon, 06 Aug 2018 13:48:23 GMT

Can you plz elaborate more about the flag ? How to add it ?

Re: How to compare two similar data sets using a chart function ?

sunny_talwar — Mon, 06 Aug 2018 13:58:18 GMT

I am not sure what is there to elaborate... but I can show you via a sample script... may be that will help clarify

Data:

LOAD blahblah...,

'OldData' as DataFlag

FROM OldData;

Concatenate (Data)

LOAD blahblah,

'NewData' as DataFlag

FROM NewData;

Now use DataFlag as your dimension

Re: How to compare two similar data sets using a chart function ?

Anonymous — Tue, 07 Aug 2018 10:45:48 GMT

For the above code, data should be in different files/sheet right ?

It should not be appended.

Re: How to compare two similar data sets using a chart function ?

PrashantSangle — Tue, 07 Aug 2018 10:50:01 GMT

Can you post some sample data???

Regards,

Re: How to compare two similar data sets using a chart function ?

sunny_talwar — Tue, 07 Aug 2018 11:01:44 GMT

Not sure I understand