topic Re: sum in QlikView

sum

upaliwije — Sun, 15 Nov 2015 04:40:01 GMT

Hi,

In my QV documents I have following Pivot TAble

			No of Items
ITEM	VALUE	U_COST	=(VALUE)/(U_COST)
Card Printers	3,840,000	160,000	24
Structured Data 1 point	6,000	6,000	1
TFT Panels	168,000	14,000	12
UPS (650VA)	748,000	8,500	88
Total	4,762,000	646,500	7.365815932

Expected Value 125

Pls help me to arrive expected Value (125)in total row of No of Items

Re: sum

sunny_talwar — Sun, 15 Nov 2015 04:42:15 GMT

I think you won't be able to achieve the result you are hoping to see with column labels. You will need to use the expressions with Aggr () function like this:

Sum(Aggr(Expression for VALUE/Expression for U_COST, ITEM))

Re: sum

upaliwije — Sun, 15 Nov 2015 04:46:39 GMT

Thanks Sunny,

What do mean by Expression for VALUE/

Expression for U_COST

Can you elaborate little more pls

Re: sum

sunny_talwar — Sun, 15 Nov 2015 04:48:16 GMT

Are VALUE and U_COST field names from your database?

Re: sum

upaliwije — Sun, 15 Nov 2015 05:39:32 GMT

Yes Those are fields in my database

Re: sum

sunny_talwar — Sun, 15 Nov 2015 05:41:46 GMT

Try this:

Sum(VALUE/U_COST)

Sum(Aggr(VALUE/U_COST, ITEM))

Re: sum

sunny_talwar — Sun, 15 Nov 2015 05:47:42 GMT

Here is a sample:

Re: sum

upaliwije — Sun, 15 Nov 2015 06:03:27 GMT

thanks Sunny

Re: sum

sunny_talwar — Sun, 15 Nov 2015 06:03:54 GMT

No problem