Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
agastya
Creator
Creator

Sum(x) i.e Rowno(Total)

I WANT SUM(X) X IS ROWNO(Total) i.e 17 now i want sum(x) i.e 153

x is handled UI level not in script level stalwar1swuehlsagarjagga

thakns in advanceCapture4.PNG

3 Replies
Anil_Babu_Samineni

If you want to use in Script? You can call like

Sample:

Load ID1, AutoNumber(Rowno(), ID1) as ID From Table;

Left Join(Sample)

Load Sum(ID) as x Resident Sample Group By ID1;

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Digvijay_Singh

Do you want 17 as Column total? You said you want Sum(X) and your table already show Sum of X column i.e 153. More info will help to understand the requirement.

vishsaggi
Champion III
Champion III

Where do you want to show 153? Did you try like Sum(TOTAL x) ?