topic Re: Remove - from Bar chart dimension in QlikView

Remove - from Bar chart dimension

Anonymous — Thu, 28 Jan 2016 11:50:04 GMT

Hiya

I currently get - in my bar chart because the values are not recognised.

How do i rename this to Other?

See attached pic

sunny_talwar — Thu, 28 Jan 2016 11:52:15 GMT

You can try something along these lines:

If(Len(Trim(Age)) = 0, 'Other', Class(Age, 20))

MayilVahanan — Thu, 28 Jan 2016 11:53:30 GMT

Try like this

=If(Isnull(AgeRange),'Other', AgeRange)

sasikanth — Thu, 28 Jan 2016 11:55:23 GMT

HI,

You dont wan to show these values in chart other than specified ranges

then

check the option "Suppress Null values " in dimension tab

Anonymous — Thu, 28 Jan 2016 12:00:20 GMT

This is what ineeded, Thanks

Anonymous — Thu, 28 Jan 2016 12:00:38 GMT

Two options:

1) These are null values, you can go for Checking Suppress Null Value option

2) I am assuming you have created data bucket at script level, then you can do this as well?

If(Days>0 and Days<100, '0-100',

If(Days>100 and Days<200, '100-200',

If(Days>200 and Days<300, '200-300', 'Others') as Bucket //In last bucket IF condition mention other in Else part of IF.

Anonymous — Thu, 28 Jan 2016 12:01:00 GMT

Thanks Sunny again for being Helpful