Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

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

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

order npo.revenue elementrevenueHeader 4
Ord1material240
ord1labour100
ord1others30
ord2material300
ord2labour250
ord2others120

.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.

4 Replies
mato32188
Contributor III

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

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

balrajahlawat
Esteemed Contributor

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

try with this expression?

=sum(Total <Revenue Element> Revenue)

or

=sum(All Revenue)

MVP
MVP

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

HI,

Try like this using set analysis

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


Hope this helps you.


Regards,

jagan.

Not applicable

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

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

Community Browser