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: 
Not applicable

How to hide specific values in a stacked bar chart?

Hello Community,

i have created a stacked bar chart where i have different "status" for different "days".

status_test-pic.PNG

I dont want to show if a day has only the status "start" like the 30.04.2016 in the picture.

How can i hide this?

Tank you really much for your help!

Greetings,

Florian

21 Replies
tomasz_tru
Specialist
Specialist

but it won't hide the day.

Tomasz

agigliotti
Partner - Champion
Partner - Champion

i forgot to say to uncheck "Include zero values" option.

Not applicable
Author

bu i want to keep the "start" status from the other fields, if a day  has more than 1 status

agigliotti
Partner - Champion
Partner - Champion

yes that's why I wrote as below:

count( distinct Status) = 1 and Status = 'Start'


it means only Days with only one status equal to 'Start' will be hide.

Not applicable
Author

yes, but the status "start" is complete missing in the other dates too now.

agigliotti
Partner - Champion
Partner - Champion

maybe I didn't understand your data model because It should works.

tomasz_tru
Specialist
Specialist

'count( distinct Status)' in condition will be calculated for every dimension value - so it would be 1 for every day - that's why 'Start' disappeared.

agigliotti
Partner - Champion
Partner - Champion

ok then try with:

count( TOTAL <Day> distinct Status) = 1 and Status = 'Start'

bharani8
Creator III
Creator III

This is working!! Cool

bharani8
Creator III
Creator III

=if( count( TOTAL <Day> distinct Status) = 1 and Status = 'Start', 0, count( Status ) )