Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
ilanbaruch
Specialist
Specialist

Dim Titles in bar chart

hi all

in my model i have a bar chart -

i want to change the dim value titles, i.e instead of 2019/Q1 ->  '19-Q1'

any ideas ?

advanced thanks

 

 

 

 dim titles.png

Labels (1)
1 Reply
Claudiu_Anghelescu
Specialist
Specialist

=mid([Year Quarter],3,2) & '-' & right([Year Quarter],2)

 

my sample:

=mid('2019/Q1',3,2) & '-' & right('2019/Q1',2)

 

 

To help community find solutions, please don't forget to mark as correct.