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

Filter the chart type based on condition (in other work Pie if +, bar if any - value

Hi,

I'm looking for a way to display the right chart type based on value.

I've defined a chart which is either on bar or pie but I would like the pie to be excluded (so bar display) when I have negative value

Is this possible?

Thanks for your help

2 Replies
Not applicable
Author

You can use conditional layouts.  See attached.

Not applicable
Author

Thanks Rebecca. I undertand your example but cannot replicate it on my data.

I don't know which dimension (other than my sum) I should check as the user can select any...

My expression in my graph is sum([Rev.Amount rev])....

I tried =if((Min([Rev.Amount rev]))<0,0) but the condition is always on so I cannot see the graph....

What I would need is the same condition that took into account my current selection in test...I tried

=if((Min({$} [Rev.Amount rev]))<0,0) but it's not working

Should I incorporate an =agg function as well?