Discussion board where members can get started with Qlik Sense.
If there is a field name (period_num) having months 1 to 13 & there is another field(ftm). According to the requirement I want to consider till (period_num)=12, such that ftm of period_num=13 is added in ftm of period_num =12
Maybe sthing like this :
//Suppose this is your current table
load * inline [
//what you should do
load num,sum(ftm) as FTM group by num ;
load num, ftm Resident ftm where num<>12 and num<>13;
load num, sum(ftm) as FTM group by num;
load '12' as num, (ftm) Resident ftm where num=12 or num=13;
drop table ftm;
That did the trick?
Then please, don't forget to close the thred by marking the correct answer as correct.