topic Re: Rangesum in QlikView

Rangesum

sijojoseph22 — Tue, 15 Sep 2015 08:54:36 GMT

Hi All,

We need to fill the 'salary Triangulations' with the above value if the below value is null or zero and if the value exist the value should display.

i.e. for the Month from 5 to 8 it should come 1000 and then for 9 it should be 2000 and for month 10-11 it should be 2000 and should go on like that.

Currently the formula I applied is taking the sum and displaying it i.e. 1000 +2000 and displaying the sum of 3000.

Attached the excel sheet and qvw. Please adivse

Thanks,

Sijo

sunny_talwar — Tue, 15 Sep 2015 09:00:19 GMT

Are you trying to do this in the script or on a front end chart? Cannot open your QVW as I am working with personal edition of QlikView.

sijojoseph22 — Tue, 15 Sep 2015 09:01:25 GMT

I am trying to do this in chart, not in script

sijojoseph22 — Tue, 15 Sep 2015 09:03:46 GMT

Add the image with the field Desired output

sunny_talwar — Tue, 15 Sep 2015 09:17:37 GMT

See if this helps:

Expression: If(Sum123 = 0, Alt(Above(Sum123), 0), Sum(Salary))

Here Sum123 is the expression label and hence it is Blue in color.

Anonymous — Tue, 15 Sep 2015 09:27:29 GMT

hi sijo,

If(len(trim(Sum(Salary))) = 0, Above(Sum(Salary)), Sum(Salary))