topic Re: Special bar chart in QlikView

Special bar chart

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Special bar chart

Gysbert_Wassenaar — Thu, 30 Jun 2016 16:28:59 GMT

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

Re: Special bar chart

satishkurra — Thu, 30 Jun 2016 16:36:43 GMT

You can use Gysbert expression

You can also use expression below

RangeMax(Sum(Amount),0)

Re: Special bar chart

sunny_talwar — Thu, 30 Jun 2016 16:39:08 GMT

Gysbert's expression would be an equivalent of this:

Sum(RangeMax(Amount, 0))