Greetings to all,
I have requirement, in which I need to show trends for 6 quarters,6 months and 30days rolling.
My main concern is how to store these rolling data in qlik for these 6quarters,6months and 30days rolling.
FYI, we are getting parameterize cv from HANA, without any date column. So that by parameterize we may can load data according to our need by variable.
Currently I am storing 540days data, but we need quarters data from todays date, month end for last 6months rolling from todays date and from todays date last 30days.
for me these 510days data is of no use, its just impacted dashboard performance and qvd is not currently in picture in our organization.