Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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))