Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Saravanan_Desingh

Bar Chart - Suppress Dimension if Expression is NULL

I have a situation here.

Capture.PNG

Dimensions : Strategic Direction & Site

Expression : Count(Name)

I want to suppress the Sites which didn't turn any value. I'm getting perfect output in Pivot Table.

But if I change it to Bar chart, I'm getting the above.

Suppress Null and other related options didn't work here.

Any suggestions here please? Thanks..

10 Replies
sunny_talwar

You can check 'Suppress When Null' on the presentation tab of chart properties.

sunny_talwar

I guess this did not work for you. May be try this as your calculated dimension

Aggr(If(Count(Name) = 0 or IsNull(Count(Name)), Null(), [Strategic Direction & Site]), [Strategic Direction & Site])

Check 'Suppress when Value is Null' on the Dimension tab

Saravanan_Desingh
Author

Hi Sunny,

Thanks for your response.

There are two dimensions Strategic Direction and Site.

Based on your Calc-Dim, I have changed my case as below:

=Aggr(If(Count({<Freq={0}>}REMS_City), Site ,Null()), [Strategic Direction], Site)

But, as default all the Site names are coming. Not sure. Capture.PNG

sunny_talwar

Would it be possible to share a sample?

Saravanan_Desingh
Author

Please find the attachment. !

sunny_talwar

I guess this would be backdraw of using 2 dimensions and 2 expressions. How about the attached

Saravanan_Desingh
Author

Thanks Sunny. This is very helpful.

But still if you get any other idea, please share it with me. Thanks again..

sunny_talwar

May be swuehl‌ has a trick in bag for us

settu_periasamy
Master III
Master III

Hi Saran,

As i know, there is no other way to do this. You need to make it as a single dimension (using '&' ) , so your 2 expression will be stacked. already sunindia suggested..

Just a small amendment..

i think, we don't need Aggregation. Just try

=[Strategic Direction]&Repeat(chr(160),6)& Site

Capture.JPG