Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Special bar chart

Hi,

I would like to create a bar chart, but I need to use just a few fields from the table. I've got positive and negative values. I just need positive values, but i don't have any idea for expression. Can anybody give me some tips how to write it?

Thanks,

Aleksandra Siwierska

1 Solution

Accepted Solutions
Gysbert_Wassenaar

You can filter out the negative values in a set analysis expression: Sum({<Amount={'>0'}>}Amount)


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar

You can filter out the negative values in a set analysis expression: Sum({<Amount={'>0'}>}Amount)


talk is cheap, supply exceeds demand

View solution in original post

satishkurra
Specialist II
Specialist II

You can use Gysbert expression

You can also use expression below

RangeMax(Sum(Amount),0)

sunny_talwar

Gysbert's expression would be an equivalent of this:

Sum(RangeMax(Amount, 0))