topic Re: already sum in expression in QlikView

already sum in expression

capriconuser — Wed, 13 Mar 2019 11:28:18 GMT

i have a filed "Amount" in that i already done this in script

load

id,

sum (amount)

from abc

group by id

now i am trying to add expression like this

({<id={'1'}>} amount)

but this does not work any help

here in expression i dont want to add sum because this sum is already in script

Re: already sum in expression

Gysbert_Wassenaar — Wed, 13 Mar 2019 11:35:22 GMT

You should just use sum so you and others understand what kind of measure you created. But if you really don't want to use sum, then use avg or min or max or the only() function. Only({<id={'1'}>} amount).

A chart expression is always aggregated. Even if you don't specify an aggregation function. In that case the only() function is applied implicitly. If you want to use set analysis then you must explicitly use an aggregation function.

Re: already sum in expression

capriconuser — Wed, 13 Mar 2019 11:41:49 GMT

i used only expression but figures is going to display like this ' - '

i dont want to use sum because i already use in script

Re: already sum in expression

Gysbert_Wassenaar — Wed, 13 Mar 2019 11:43:17 GMT

post a small qlikview document that illustrates the problem

Re: already sum in expression

capriconuser — Wed, 13 Mar 2019 12:01:09 GMT

check attached file

Re: already sum in expression

capriconuser — Wed, 13 Mar 2019 12:17:17 GMT

any help

Re: already sum in expression

kishorj1982 — Wed, 13 Mar 2019 13:26:05 GMT

This should work,

load

id,

sum (amount) as amount

from abc

group by id

Re: already sum in expression

capriconuser — Thu, 14 Mar 2019 04:46:08 GMT

i think you did not read my question properly

Re: already sum in expression

capriconuser — Thu, 14 Mar 2019 04:46:38 GMT

@Gysbert_Wassenaar any solution

Re: already sum in expression

Gysbert_Wassenaar — Thu, 14 Mar 2019 07:39:33 GMT

You did not calculate the sums in the script per code_name, but per combination of code_name AND name AND Update_Date. That means there is no single figures value for a single code_name value. And that means you MUST use the sum function in your chart expression if you want to sum all the different figure values that exist for a single code_name value.

Or select a single date. If you do that you will see that your expression with Only() does return a result.

Re: already sum in expression

capriconuser — Thu, 14 Mar 2019 08:08:50 GMT

i already applied sum on amount field t hey when i apply sum on code_name?