Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Lucky1
Creator
Creator

How to change label name dynamically

 

Hi I have created one measure using below formula for maximum month items

=count({<Flag={1}, Closed_MonthSerial= {"$(=Maxstring([Closed_MonthSerial]))"}>}Item_Id)

 

i want to show Label name as 'july month items' instead of current month

how to do that

 

 

Lucky1_0-1690282557685.png

 

4 Replies
md_talib
Contributor III
Contributor III

You can change it data Label field 

use this 

=Closed_MonthSerial&' '&'month items'

Lucky1
Creator
Creator
Author

Thanks for reply

unfortunately i have used It is giving - null value

md_talib
Contributor III
Contributor III

if its not working then you need to check your month field in the calendar. 

you might find the issue. as it showing null value there must be an issue with the month field. 

nehakakar
Contributor
Contributor

You can follow the steps..

1. Create a variable called Variable Overview and that holds the label name for the selected month.

ex:

LET vLabelName = 'July month items';

2. Modify your expression to use the variable in the label instead of the static text

=count({<Flag={1}, Closed_MonthSerial= {"$(=Maxstring([Closed_MonthSerial]))"}>} Item_Id) as [$(vLabelName)]

Therefore

You are dynamically setting the label name to the value stored in the variable vLabelName.

 

I hope it help you.