Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
balaji_m
Partner - Contributor III
Partner - Contributor III

Dynamic Column Names

Hi Team,

I have a requirement like this.

Below are the field Names

[2016 Actual]

[Q3 Target Letter Plan YTD Aug]

My Requirement is the Hardcoded Values like Year, Month has to changed dynamically in the script level.

The data will be loaded on 15th of every month.

So it should be Current Month - 1 and the Year should be calculated as Current Year

Need your inputs on this.

Regards,

Senthil

1 Reply
petter
Partner - Champion III
Partner - Champion III

It could be done like this:

2018_01_05_08_22_15_Qlik_Sense_Desktop.png