topic Re: Dim Titles in bar chart in QlikView

Dim Titles in bar chart

ilanbaruch — Wed, 19 Jun 2019 10:23:46 GMT

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

Claudiu_Anghelescu — Wed, 19 Jun 2019 13:53:34 GMT

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

my sample:

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