QlikView App Dev

[adil_hussain]

Hi All

I am trying to hide Fields in Barchart

Eg

Dimensions are: Department

Sales

Ops

Management

Unknown

How can i hide Unknown?

I am doing a stacked Bar Chart in %

[balrajahlawat · Accepted solution]

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

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

[sunny_talwar]

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)

[balrajahlawat]

Also dont forget to tick suppress with null vlaues

[amit_saini]

Hi Adil,

Front end:

if(Department<>'Unknown', Department)

Script side :

Load ----

-----

From

where Department<>'Unknown';

Thanks,

AS

[adil_hussain]

Thanks All for help!

Managed to fix this

LOVE QLIKVIEW!!!

[sunny_talwar]

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 --&gt; bad performance)