topic Re: Sum(x) i.e Rowno(Total) in QlikView

Sum(x) i.e Rowno(Total)

agastya — Sat, 24 Feb 2018 07:45:13 GMT

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 stalwar1‌swuehl‌sagarjagga‌

thakns in advance

Re: Sum(x) i.e Rowno(Total)

Anil_Babu_Samineni — Sat, 24 Feb 2018 16:44:58 GMT

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;

Re: Sum(x) i.e Rowno(Total)

Digvijay_Singh — Sat, 24 Feb 2018 21:29:55 GMT

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.

Re: Sum(x) i.e Rowno(Total)

vishsaggi — Sat, 24 Feb 2018 23:45:11 GMT

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