Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

balaji_m
New Contributor II

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
MVP
MVP

Re: Dynamic Column Names

It could be done like this:

2018_01_05_08_22_15_Qlik_Sense_Desktop.png