Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to create a Year drop down in my QLIK SENSE report. I got two options
1. In my QVD I have a Date column called "Period". Now I want to select only Distinct Year from that column. But I am not able find the right logic. This is what I wrote but the out put count is showing 1million records.
YearTable:
LOAD
distinct year(PERDT)as "Year"
FROM [lib://GPG_QVD/BrightScope\SI_AUM_GlobalFunds.qvd]
(qvd);
2. Or I want to create a for each loop in a inline table from the year 2006 to current year.
Example: for (i=2006, i<=year(timestamp),i++){}
Can some one please guide me in the right direction.
Thanks,
-Vidya
I tested your first script on a small data set and it returns 1 record for each year. I would verify that the PERDT field is formatted correctly as a date or timestamp.