Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sunitha_chellaiah
Partner - Creator
Partner - Creator

Table and Text Object Value Mismatch

Hi,

I want to get sum of rows value as final value in my text.

Kindly see the below screenshot.

Here, what i want is 2.78%(25% column) to be displayed in text object. this 2.78 % i am getting by enabling total function as sum of rows.

to calculate 25% , I have used this formula

 

if(sum(NET_WT)>sum(PJTD_SALE_WT),(25/count(TOTAL DISTINCT BRANCH_CLEAN))/100)

 

sunitha_chellaiah_0-1651237132573.png

@sunny_talwar 

Qlik Sense Business 

Thanks

 

Labels (4)
1 Solution

Accepted Solutions
rubenmarin

Hi, you can try with:

Sum(Aggr(if(sum(NET_WT)>sum(PJTD_SALE_WT),(25/count(TOTAL DISTINCT BRANCH_CLEAN))/100),Category,Branch))

View solution in original post

4 Replies
rubenmarin

Hi, you can try with:

Sum(Aggr(if(sum(NET_WT)>sum(PJTD_SALE_WT),(25/count(TOTAL DISTINCT BRANCH_CLEAN))/100),Category,Branch))

vish123
Creator III
Creator III

Hi Sunitha,

please try this,

if(sum(NET_WT)>sum(PJTD_SALE_WT),(25/aggr(count(TOTAL DISTINCT BRANCH_CLEAN),Category,Branch))/100)

hope this helps.

 

sunitha_chellaiah
Partner - Creator
Partner - Creator
Author

Thank you for your response

sunitha_chellaiah
Partner - Creator
Partner - Creator
Author

Thank you @rubenmarin , it's working.