Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
robert2012
New Contributor III

sum(if) for a specific selection

Hi all,

I want to use the sum(if)-function for a specific selection (all values between 3999 and 5000). My idea is like this, but it doesen't work:

sum(if(booking> 3999 and booking< 5000, cost)) as cost_special

Thank you for your help!

Tags (1)
1 Solution

Accepted Solutions
er_mohit
Honored Contributor II

Re: sum(if) for a specific selection

try this

sum(rangeonly(if(booking>3999 and booking<5000,cost)as cost_special

10 Replies
Not applicable

Re: sum(if) for a specific selection

Hi,

Try this

IF(SUM(booking)>3999 AND SUM(booking)<5000,cost) as cost_special

er_mohit
Honored Contributor II

Re: sum(if) for a specific selection

try this

sum(rangeonly(if(booking>3999 and booking<5000,cost)as cost_special

Not applicable

Re: sum(if) for a specific selection

sum( total if(booking> 3999 and booking< 5000, cost)) as cost_special

Not applicable

Re: sum(if) for a specific selection

Hi,

Try this

IF(SUM(booking)>3999 AND SUM(booking)<5000,SUM(cost)) as cost_special

sivarajs
Valued Contributor II

Re: sum(if) for a specific selection

sum({<booking={">3999<5000"}>}cost)

robert2012
New Contributor III

Re: sum(if) for a specific selection

Thank you, but it doesn't work. QV says that there is a skript mistake.

robert2012
New Contributor III

Re: sum(if) for a specific selection

Thank you, but it doesn't work. QV says that there is a skript mistake.

sivarajs
Valued Contributor II

Re: sum(if) for a specific selection

Set analysis wont work with script.Did you use Group by clause in your table

Load * sum(x)as tmp

from x.qvd group by y;

robert2012
New Contributor III

Re: sum(if) for a specific selection

Thank you very much!! It works...

Community Browser