Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
gbernabo
Contributor II
Contributor II

Year to date in load editor

Dear all, I'm trying to calculate the year to date (YTD) from the data load editor.

I have a month and year date field (myDate) and another field with the order of the dates from myDate. So the most recent month and year is zero in order, last month is 1 and so on for 24 months.

How do I create a YTD field in the data load editor so that every month that I reload with new data that field updates.

Thanks in advance.

Best,

Guille

Labels (5)
1 Reply
Usama
Creator
Creator

Hi,

You can create YTD (using Set Analysis) across the required dimension in straight table. That would be the best practice.

Thanks,

Usama

From Nothing - To Something - To Everything