Comparison of previous file and current file

[#1]

Hi all,

I created an application , in which I took multiple files of excel. Please find sample data in attachments.

As per attachments,

I extracted date and year from file name as project date and project year which I am using as filters.

I want to create a new column 'Status' in straight table and  wanna compare X1,X2,X3,X4 of the latest two files .If the data is same it should show as 'Same' else 'Changed'.

Any help would be appreciated.

Thanks in advance

Regards,

Priya

[sushil353]

do u want to solve this on script level or in a chart..??

if it is chart then create a expression and put something like =if((table1.X1-table2.X1)=0,'no change','change').

HTh

sushil

[#3]

Thanks for quick reply sushil.

I wanna make it in chart. Your expression is helpful.

Just wanna make you more clear on this.

In my application I extracted a large number of excel files. Where Date will be the key. Now here I should compare a field 'x1' from  two latest files.

Then if data is changed ,then it should show as Chnaged else same.

I unable to compare two latest files in expression. Can i use set analysis?

Can you please help me

Thanks in advance

[sushil353]

Please post sample data...which you want to compare...

[jyothish8807]

Hi,

    First of all re name other fields and keep only one primary key ( Date in ur case)

For example .in sheet1 if u have column Name then in sheet 2 make it Name2.

Then on your chart use the following expression.

if(Name=Name2,'No Change','Changed')

Regards

Jyothish KC

[jyothish8807]

Make sure that you change the column name on the backend of Qlikview after importing and not on the Excel Sheet.

Regards

Jyothish KC

[#7]

Sorry a bit late reply.

PFA for sample data

Thanks in advance