Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
rajuamet
Partner - Creator III
Partner - Creator III

How to remove null valued dimension in a bar chart ?

Hi Techies,

In a bar chart I have Month_Yr as first dimension and Client as second dimension. Also I have 3 expressions.

For Example:

I have 5 clients as A, B, C, D, E.

In the Month_Yr : Apr_16 , we have only C as client. But in bar chart for Apr_16 it displays all the clients. Here I want to show only C for Apr_16.

Likewise across all Month_Yr only available clients should come !...

How to achieve this.

Regards,

Rangaraju.

13 Replies
Not applicable

Hi Rangaraju,

As per my understanding, Axis text is showing properly in the middle only, But in Mar_16  dont have values for clients B,C,D,E thats why it looks that.

In  Feb_16 we have all the values thats where u can see axis values in the middle.

vishsaggi
Champion III
Champion III

That is strange. I have just downloaded the same app i sent you earlier. It is displaying this

are you doing any changes in axes or presentation tab ?

Capture.PNG

rajuamet
Partner - Creator III
Partner - Creator III
Author

No, I did not change anything. Will it be due to different versions??? I am using QlikView 11.20 SR5.

vishsaggi
Champion III
Champion III

Could be possible, i am not pretty sure if it is with the version. Mine is QV11.20 SR12.