How to get the totals in qliksense

[anuhegde]

Hi all,

Below is my data.

Customer	Funded	Funded %	Funded% formula
ABC	-322946.7162	26.85%	ABC Funded/total
DEF	-293840	14.11%	DEF Funded/total
GHI	-265018.6522	14.82%	GHI funded /total
JKL	-170270.7929	11.18%	JKL funded/total
MNO	-150599.8534	11.13%	mno funded/Total
Total	-1202676.015

I'm struggling to write the Funded% formula in Qlik Sense. Could you please help?

Regards

Anusha

[vinieme12]

as below, use the total keyword

sum(Funded)/sum(TOTAL Funded)

[anuhegde]

Yes. I did the same. But the problem is that, if I limit the dimension values , the total should come for only those dimension values. It should not consider all.

Example: In the above table,  there are 5 customers and the total of 5 customers is -1202676.015. Suppose if I limit the customers to 3, then also total will show -1202676.015. But the correct total for 3 customers is  -881805.3684. How to get 881805.3684 if we limit the customers to 3?

[vinieme12]

How exactly are you limiting the dimension? that could be the problem

[anuhegde]

Hi Vineeth,

Im doing it from the dimension properties: