Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
danosoft
Specialist
Specialist

Group Label substring

Hi i have a chart, with group cycle, my label will be display as you see in my chart:

i want to display only 3 character of my label (example SET, OTT, NOV, DIC etc...)

as the same when i change in the cycle i want to display only some character not all

Can i do that?

5 Replies
jaumecf23
Creator III
Creator III

In the chart propierties you can find the following option:

Captura.PNG

danosoft
Specialist
Specialist
Author

ok thank, that can be an idea, but i see for my "month" element in group cycle can be ok, but for the "channel" element in group cycle is not good.

Is possible to filter the value of the group with IF ?

for example:

for element "month" in my group cycle:

if MONTH = 01 write 'JAN'

for element "channel" in my group cycle:

if channel = 'ext' write 'prova canale'

thanks

jaumecf23
Creator III
Creator III

In the Group Settings there is an option to add some logic like to create a Calculated Dimension. Click in the Edit button as you can see in the next screenshot:

But maybe the best idea is to create another field in the script with the logic there. Then use this new field as dimension in the cyclic group.

Captura.PNG

danosoft
Specialist
Specialist
Author

Thanks, yes i already did that for dimension Month, i wanted not do the same for others fields, i thougth can be do that directly in the chart... but i see i can't do in the chart directly

Btw thanks

danosoft
Specialist
Specialist
Author

becouse...i use this group in a chart where i want all my month name is full, and in a chart where i want my month name is substring, the same for the "channel" item, in a chart i want the EXT value (the normal value) in another chart i want the EXT value converted.....