Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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

1 Solution

Accepted Solutions
agigliotti
Honored Contributor II

Re: How to hide specific values in a stacked bar chart?

ok then try with:

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

21 Replies
bharani8
Contributor III

Re: How to hide specific values in a stacked bar chart?

Try this..

Count({<Day -= {'MENTION DATE'}>}Status)

bharani8
Contributor III

Re: How to hide specific values in a stacked bar chart?

I think i got the question wrong.. let me try other way

tomasz_tru
Valued Contributor

Re: How to hide specific values in a stacked bar chart?

change your measure to:

Count({$<Status={"start"}>}Status)

tomasz_tru
Valued Contributor

Re: How to hide specific values in a stacked bar chart?

Skip it - I misunderstood your question, and can't delete the post.

Tomasz

chinnuchinni
Contributor III

Re: How to hide specific values in a stacked bar chart?

You can once try with this

count({<Status-={'Start'}>}Status)

bharani8
Contributor III

Re: How to hide specific values in a stacked bar chart?

May it works.. not sure though..

=if(Status <> 'Start',count(Status))

Please attach ur qvw file

agigliotti
Honored Contributor II

Re: How to hide specific values in a stacked bar chart?

try this expression:

=if( count( distinct Status) = 1 and Status = 'Start', 0, count( Status ) )

Not applicable

Re: How to hide specific values in a stacked bar chart?

I have attached the file.

Not applicable

Re: How to hide specific values in a stacked bar chart?

now is every field wich contains "start" missing.

Community Browser