I am now creating a new App in qliksence. I am having two excel files whose Header will not change any day. My main goal is to compare the two files and if there is any change Qliksence should let me know.
Now i am in to a task, in a column of old file there will be data filled like CAT0, CAT1, CAT2, CAT3, CAT4, CAT5 and CAT 9. In the new file also the same will be filled but the main thing here is, if the changes between old file and new file is coming down (for eg- in old file if it is CAT 9 and in new file it is CAT 5), qliksence should say it is positive difference if it is going up (for eg- in old file if it is CAT 5 and in new file it is CAT 9) it should say, it is Negative difference. Can anyone help me on this.
Please find the below tables which shows what are all the set analysis i need to do.
Sorry Gysbert, I have not clearly understood what do you require to answer me. This is the reason why I have blabbered something previously.
Hope you want me to upload the 2 files with which I am working. I am uploading it. If I have not fulfilled your expectation, kindly advise me.
You can find two fields in the files. Tracking and Category. Here Tracking is my key and with respect to it, I want to check the change in Category between the two files. Mainly if the Category changes to CAT 0 from any other previously specified, I need to track it. I will also share a syntax which I tried, hope this will help you in understanding better.
if(("Category Old"="CAT 9","CAT 5","CAT 1") and ("Category New"="CAT 0"),'CAT 0 is updated','No CAT 0 is Updated)