topic Re: Hide Names in Bar Chart in QlikView

Hide Names in Bar Chart

Anonymous — Wed, 27 Jan 2016 10:49:56 GMT

Hi All

I am trying to hide Fields in Barchart

Dimensions are: Department

Sales

Ops

Management

Unknown

How can i hide Unknown?

I am doing a stacked Bar Chart in %

Anonymous — Wed, 27 Jan 2016 10:52:55 GMT

If 'Unknown' in your department as a string, then use calculated dimesnion like this?

Replace Department with =if(Department<>'Unknown', Department)

sunny_talwar — Wed, 27 Jan 2016 10:56:01 GMT

You can also use Set analysis in your expression to hide UNKNOWN:

Lets say your expression is Sum(Sales), you can change it to Sum({<Department - ={'Unknown'}>}Sales)

Anonymous — Wed, 27 Jan 2016 10:59:53 GMT

Also dont forget to tick suppress with null vlaues

amit_saini — Wed, 27 Jan 2016 11:08:18 GMT

Hi Adil,

Front end:

if(Department<>'Unknown', Department)

Script side :

Load ----

-----

From

where Department<>'Unknown';

Thanks,

Anonymous — Wed, 27 Jan 2016 11:10:46 GMT

Thanks All for help!

Managed to fix this

LOVE QLIKVIEW!!!

sunny_talwar — Wed, 27 Jan 2016 11:35:45 GMT

For a better performance, if you have a lot of data (and not too many expressions), to use set analysis over calculated dimension. (Calculated Dimension and conditional dimension --> bad performance)