Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.