Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

gwassenaar‌; hic‌  please comment

snap1.png

OutletProduct (IPL)No of CR Pack OnNo Of CR Bulk OnCore Range On premisee9LE Bulk9LE Pack onCore Sold Onm premise
2040038545356011000
2040038545778000100
2040038545779000010
2040038545791000010
2040038545794011101
2040038546488000100
2040038546598000100
2040038546896000010
2040038546979101000
2040038547128011101
2040038547137101000
2040038547265101000
2040038547430011000
2040038547492000010
2040038547739011000
2040038547768011101
2040038547771101000
2040038547853101000
2040038547875011101

Thanks

Sarfaraz

2 Replies
shwetagupta
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)

sarfaraz_sheikh
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

Community Browser