How to get sum of three rows and put it in one row in table in qliksense?

[#1]

There is set of data that loaded into the data loader as shown  below

order npo.	revenue element	revenue	Header 4
Ord1	material	240
ord1	labour	100
ord1	others	30
ord2	material	300
ord2	labour	250
ord2	others	120

.Now i want to show this in table chart...so for each order i want the total revenue...that is sum of all the material labour and others revenue...its not accepting the sum function...is there any function that i can use to get the required output..

please do let me know how to proceed.

[mato32188]

Hi,

have you tried to create table chart with dimension field Order npo. and measure field using :

sum( {<[revenue element]= {'material', 'others'}>} revenue)?

BR

Martin

[Anonymous]

try with this expression?

=sum(Total <Revenue Element> Revenue)

or

=sum(All Revenue)

[jagan]

HI,

Try like this using set analysis

=sum(Total <[order npo.]> Revenue)

Hope this helps you.

Regards,

jagan.

[#5]

From looking at the formatting of your table - it looks like [revenue] might not be stored as numeric - which would explain why the sum function isn't working.

Perhaps try the NUM function around the [revenue] field in your load script