Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
julian_rodriguez
Partner - Specialist
Partner - Specialist

Dynamic Label for Dimensions/Measures?

I'm using this label for a Measure:

= 'Sales ' & Max(Year)

I was expecting that the visualizations shows: Sales 2014, for example.

But, instead of this, it shows the formula: = 'Sales ' & Max(Year)

How can I get that dynamic label?

Sense.JPG.jpg

25 Replies
Josh_Good
Employee
Employee

Hi Andrea,

At this point only higher level details of 3.0 have been released.  Full details on all changes include in 3.0 are typically not released in advance.  So unfortunately we'll have to wait a month or so until 3.0 ships.

-Josh

Qlik

agigliotti
Partner - Champion
Partner - Champion

still not available in latest version 3.1 !!!

the customer needs it.

IT'S URGENT !

shraddha_g
Partner - Master III
Partner - Master III

As a workaround you can show it in title or sub title of chart

agigliotti
Partner - Champion
Partner - Champion

yes i know but i need to show in table column label ex. 'Sales ' & Max(Year) and in other 'Sales ' & Max(Year)-1.

Chanty4u
MVP
MVP

Hi,

you can try

: = 'Sales ' & MaxString((Year)-1)

and

=: = 'Sales ' & MaxString(Year)

shraddha_g
Partner - Master III
Partner - Master III

In labels, it will be considered as plane text

Chanty4u
MVP
MVP

i tried in Qlikview   thanks for right  info

vlad_komarov
Partner - Specialist III
Partner - Specialist III

I would suggest that you will invest in an extension development... I know few people who can do it for you.

Ralf (rbecher‌) is one of them...

VK

agigliotti
Partner - Champion
Partner - Champion

Any news about this hot topic ???

parimikittu
Creator II
Creator II

Hi,

Create a variable in Qliksense and use the variable with $(=) sign.

For example.

if u want to name a column as Sale 2015.

Create a variable for year like $(=max(year)) with name vMax_Yr.

Use the vMax_Yr in the label as Sale $(vMax_Yr)