Discussion board where members can learn more about Qlik Sense App Development and Usage.
I am creating Qliksense application.
The user wants to compare current and previous month values.
I have derived a table which contains each months data.
i would like to calculate the corresponding previous month data in the same table.
This is my input table.
I want to derive the output table like below
My key column is the composite key(concatenating multiple columns to form a key).
Please give me your valuable suggestion to achieve this.
in load script editor follow these steps:
Subfield(Key,'_',3) as Month
from YOUR INPUT TABLE;
Peek(Amount,-2) as "Previous Amount"
order by Month,Item;
drop table tmp;
You should Left Join the table with the previous key and previous amounts to the new key. This way you will have your result.
Can you show some information from the key and previous key. Like:
To this key, 1200 is the amount, but what is the amount of the previous key. What corresponds to this and where can this information be found?