Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have an excel spreadsheet in which I store month wise data. Each month has 12 columns. Every next month, 12 columns get appended to the previous 12 columns (Data gets appended horizontally).
Is there any way to pick only last 12 columns in Qlik Sense so that I can get data for latest month?
Regards,
Aditya
Thanks for your reply. But I solved this requirement by automating the numbers appended behind field names.
For eg I have fields A, B, C. If the same fields are loaded for next month, They will be loaded as A2, B2, C2. So I automated the numeric part by using foll way:
PrevVar: // Previous month stored qvd
load
VarName,VarCount
i,1
from [lib://xyz_Nov22.qvd];
let vCurrVar=peek('VarCount',0,'PrevVar')+1;
Then I stored above table in qvd form for using values for next month (Stored for Dec 22). And also used above variable 'vCurrVar' as a suffix in the field names of my table.
Regards,
Aditya
Hi ,
Check this link ? may be helpful
Thanks for your reply. But I solved this requirement by automating the numbers appended behind field names.
For eg I have fields A, B, C. If the same fields are loaded for next month, They will be loaded as A2, B2, C2. So I automated the numeric part by using foll way:
PrevVar: // Previous month stored qvd
load
VarName,VarCount
i,1
from [lib://xyz_Nov22.qvd];
let vCurrVar=peek('VarCount',0,'PrevVar')+1;
Then I stored above table in qvd form for using values for next month (Stored for Dec 22). And also used above variable 'vCurrVar' as a suffix in the field names of my table.
Regards,
Aditya