Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
krishnacbe
Partner - Specialist III
Partner - Specialist III

Graph Issues

Hi

I have a Line Chart. I have Dimension as Date & expression =Count(ID). I need to enable a condition like A='-1' then count(ID) should reflect it.

Sample.JPG

Actual result should be 9. after selecting only i am getting the data. I need to show only exceptions team -1. this condition should be given in expression.

ActualResult.JPG

Can any one help to fix this.

Regards

Krishna

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Try

=count(if(ExceptionsTeam = -1,ID))

View solution in original post

2 Replies
swuehl
MVP
MVP

Try

=count(if(ExceptionsTeam = -1,ID))

krishnacbe
Partner - Specialist III
Partner - Specialist III
Author

Hi swuehi

Thanks a lot it working fine.

Regards

Krishna.