Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
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))