Strange values in chart label

[#1]

Hi All

I am trying to do a conditional dimension, with 'Month', 'Week' and 'Day', it works fine except the labels are getting messed up for some reason.

Please see attachment chart. As you can see there are numbers and text showing, how can this be?

My conditional expression is : =if(gatype='Day',Day,if(gatype='Week',Week,if(gatype='Month',Month)))

Thanks

Vaneshan Naidoo

[joshabbott]

It looks to me like they don't fit correctly.  Try to hold 'Ctrl'  and 'Shift' and when the objects in the chart turn red, shrink the verticle amount of the chart and see if that fixes it.  You may need to lower your font too.

[#3]

Is gatype a variable or a field?

If it is a field, make sure that you are using the "Always one selected value" option in your listbox.

[#4]

Hi Josh, I tried that doesn't work. I know this because when I change it to a single expression it works, at the moment I have a nested "if" statement :

=if(gatype='Day',Day,if(gatype='Week',Week,if(gatype='Month',Month)))

[#5]

Hi Clark, it is a field and I have that checkbox ticked.

[#6]

If that's true, isnt it weird there are both month names on your horizontal dimension axis and numbers exceeding the number of 12? It seems as if there are mixed days and months on the axis. Which is weird if gatype can only be one value.

It seems as if there are month names in your Day field, or gatype is sometimes null or an unexpected value so that your expression defaults to Month

[#7]

Yes it is really weird, there seems to be some kind of interference or data fragmenting.

I will tried to make month a number so they are consistent.

[#8]

Yes, the numbers and texts between (day,week) and month respectively was causing this bug, strange cos Qlikview suppose to work

I changed the expression to :

=if(gatype='Month',num(Month),(if(gatype='Day',Day,if(gatype='Week',Week))))