# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor III

## Row level sum in Qliksense without Aggregation

Dear Folks,

I have the below data and i want to calculate below things

1- CoreRangeOn Premise = No of CR Pack On + No of CR Bulk On

2> Core Sold On premise = (No of CR Pack on * 9LE Pack on) + (no of CR Bulk on * 9LE Bulk)

However After doing the multiplication in second column i want to show the sum of record where i get one. like in below chart if you see there total 5 times 1 appears and i want to show the row level sum against particular outlet.

OR in short the logic is No of CR Pack on and 9LE Pack on  is 1 then give 1 else 0 and then do the Sum of that 1's.

Note : Please advice the solution wihtout aggregation function as i have already done it and it is taking very long time to open chart in front end as i have very huge data. I want it to be done without Aggr function.

Is there anyway to do it in set analysis. All the above columns are calculated column and I am using Qliksense and help would  be much appreciated.

 Outlet Product (IPL) No of CR Pack On No Of CR Bulk On Core Range On premisee 9LE Bulk 9LE Pack on Core Sold Onm premise 20400385 45356 0 1 1 0 0 0 20400385 45778 0 0 0 1 0 0 20400385 45779 0 0 0 0 1 0 20400385 45791 0 0 0 0 1 0 20400385 45794 0 1 1 1 0 1 20400385 46488 0 0 0 1 0 0 20400385 46598 0 0 0 1 0 0 20400385 46896 0 0 0 0 1 0 20400385 46979 1 0 1 0 0 0 20400385 47128 0 1 1 1 0 1 20400385 47137 1 0 1 0 0 0 20400385 47265 1 0 1 0 0 0 20400385 47430 0 1 1 0 0 0 20400385 47492 0 0 0 0 1 0 20400385 47739 0 1 1 0 0 0 20400385 47768 0 1 1 1 0 1 20400385 47771 1 0 1 0 0 0 20400385 47853 1 0 1 0 0 0 20400385 47875 0 1 1 1 0 1

Thanks

Sarfaraz

2 Replies
Contributor

## Re: Row level sum in Qliksense without Aggregation

Hi

Can you please explain your problem a little more. Why do you need aggregation?

Do you need to plot this in kPI  box or corresponding to Outlet /IPL

1. CoreRangeOn Premise = No of CR Pack On + No of CR Bulk On

2> Core Sold On premise = (No of CR Pack on * 9LE Pack on) + (no of CR Bulk on * 9LE Bulk)

New Contributor III

## Re: Row level sum in Qliksense without Aggregation

Hi Shweta,

I have done the aggregation because i want to show the sum of no of 1's after multiplication against particular outlet or IPL.....I was unable to achive these  without aggregation.

But i want it to be implement without aggregation as aggregation is taking long time to reload the chart.

Kindly suggest something to do in expression itself without aggregation.

Thanks

Sarfaraz