Row level sum in Qliksense without Aggregation

[sarfaraz_sheikh]

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.

gwassenaar‌; hic‌  please comment

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

[shwetagupta]

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)

[sarfaraz_sheikh]

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