Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
risabhroy_03
Partner - Creator II
Partner - Creator II

Dynamic field name

I have a field name - 180 Days on 31st March 2021 - Qty

where 31st March 2021 is dynamic.

I have a variable that shows 31st March 2021 and will change next year.

let vASDT1 = floor(num(Date(MakeDate(Year(Today()),3,31))));

I want to incorporate this variable in my field name so that the field name automatically changes next year.

 

Pleas ehelp.

1 Reply
anat
Master
Master

can u try like

Let vtest =month(Today());


LOAD [180] as test_$(vtest);