Discussion board where members can get started with Qlik Sense.
I have the two following tables :
And I would like to have a KPI to count the number of Standard difference between the two tables, that is to say : count(DISTINCT MSN where New Standard is different from Old Standard) but I don't manage to do that.
I don't want to join tables because I have a lot of others columns so it will be very heavy and I need each table to be independant.
If you have any idea, don't hesitate
Solved! Go to Solution.
You can use exists function to know if the record is loaded earlier or not.
Load ID&OldStandard as Key
Load *,if(Exists(Key,ID&NewStandard),'No Different','Different') as Status
thank you very much, this could work ! But I would like to avoid creating a new table because my data is very heavy and it already takes a lot of time to load
Caroline Huet schrieb:... I need each table to be independant.
...but you know, that Qlik will create an outer join automatically if two tables use same fields? That means your both tables are linked because of the field "ID"...