topic Re: Dynamic labels in QlikView

Dynamic labels

Anonymous — Fri, 01 Apr 2016 12:57:10 GMT

Hi All,

My requirement is Create dynamic labels for financial year.

Label is As on 31^ST Apr’2016 for financial year starting. 2nd month Apr’2016 to May’2016.

I need change the lable dynamically.

As on 31^ST Apr’2016

Apr’2016 to May’2016

Apr’2016 to Jun’2016

Apr’2016 to Jul ’2016

Apr’2016 to Aug’2016

Apr’2016 to Sep’2016

Apr’2016 to Oct’2016

Apr’2016 to Nov’2016

Apr’2016 to Dec’2016

Apr’2016 to Jan’2017

Apr’2016 to Feb’2017

Apr’2016 to Mar’2017

As on 31^ST Apr’2017

jonathandienst — Fri, 01 Apr 2016 13:27:25 GMT

Create them from what? I suggest that you upload a sample and explain in more detail how you would like to use these labels.

Fri, 01 Apr 2016 13:44:46 GMT

Create a variable

Let vFY='Year(Addmonths(DateField,-4))'

try this lable:

=if(month(DateField)=4,Date(monthend(DateField),'DD MMM YYYY'),'Apr '&$(vFY)&' to '& Monthname(DateField))

Anonymous — Fri, 01 Apr 2016 19:36:34 GMT

Hi Jona,

I need this type of Dynamic labels and calculate head count between FY Starting month to Current month.

Please help me out.

Thanks,

Krishna.