topic Re: Is there a way to make dynamic labels for pivot table columns? in QlikView

Is there a way to make dynamic labels for pivot table columns?

kepiluna2 — Wed, 25 Nov 2020 16:16:04 GMT

I have a pivot table that displays monthly quantities in transit, outstanding po quantities, demand, and inventory ending position. I need the labels to be dynamic and be a rolling calendar. So this month is July I want to see August through January, next month it should be September through February. The problem is i set the label to be a formula such as =month(today()) for the current month, but now I have to write that formula each time I need to reference that expression in another expression. Is there any work around?

Re: Is there a way to make dynamic labels for pivot table columns?

Gabriel — Sat, 26 Sep 2020 07:55:50 GMT

Hi,

Create a variable and give the definition of the variable as the formula, then you can reference the variable anywhere you want to use the formula, see below.

LET vCurrMonth = MONTH(TODAY());

Hope it helps

Re: Is there a way to make dynamic labels for pivot table columns?

Brett_Bleess — Tue, 20 Oct 2020 17:39:10 GMT

Check the following Design Blog post too, might be another avenue to pursue:

https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130

Regards,
Brett