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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Manuel174102
Creator
Creator

Graph is showing information that I dont want to be shown

Hello!

I have the following graph, and you can see the gray on top of each year. I want to get rid of that. The grey orders are as '-' classify. I tried using the following but it did not work out : If(Order Type <> '-', sum(amount))

I know I can deselect the option " Include Null Values", but if I do that, the rest of my dashboard will not make sense. 

What can I do? Can I solve this with an if function?

 

Labels (1)
1 Solution

Accepted Solutions
Lakshminarayanan_J

@Manuel174102 

Try Writing the below expression ,

=sum({<Order Type -={"-"}>}amount)

Lakshminarayanan J
To help users find verified answers, please don't forget to use the "Accept as Solution" button

View solution in original post

2 Replies
Lakshminarayanan_J

@Manuel174102 

Try Writing the below expression ,

=sum({<Order Type -={"-"}>}amount)

Lakshminarayanan J
To help users find verified answers, please don't forget to use the "Accept as Solution" button
Manuel174102
Creator
Creator
Author

You Rock!! thank u so much!