topic Re: Sum function issue in QlikView

Sum function issue

Mon, 16 Jun 2014 07:11:00 GMT

Have a expression like below

sum(if (conditions, field ))

This working fine

But when try to get the total value

sum( total if (condition, field )) condition filter is not applied .

Getting the sum of all values .

Re: Sum function issue

its_anandrjs — Mon, 16 Jun 2014 07:15:15 GMT

Update

Try like this way

This statement is wrong All and Total not working this way because it is in the if condtion

sum(if (conditions, TOTAL field ))

Try one of this

Sum(TOTAL if (conditions, field ))

Sum(ALL if (conditions, field ))

Re: Sum function issue

Mon, 16 Jun 2014 07:17:01 GMT

that works fine... refer to the attachment

Re: Sum function issue

Mon, 16 Jun 2014 07:20:48 GMT

Have used the same formula, But I need to add that formula in expression in chart.

There its not working.

Re: Sum function issue

Mon, 16 Jun 2014 07:21:07 GMT

Giving a syntax error

Re: Sum function issue

Mon, 16 Jun 2014 07:21:59 GMT

can u share ur qvw?

Re: Sum function issue

its_anandrjs — Mon, 16 Jun 2014 07:23:16 GMT

Thats right

Try with this way

Sum(TOTAL if (conditions, field ))

Re: Sum function issue

its_anandrjs — Mon, 16 Jun 2014 07:28:59 GMT

See this small example

Raw:

load * Inline

[

Name,empid,salvalue

A,101,45000

B,102,30000

C,103,15000

D,104,20000

];

And in straight table

Dimension:- Name

Expression:- =Sum(TOTAL if (salvalue>20000, salvalue))

Result will be

Name,salvalue

101,75000

102,75000

103,75000

104,75000

What expected output you need.

Hope this helps