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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2015-08-31 04:53 AM

Aggregation Problem in Expression

Hey all,

I am stuck at a problem where we have a following expression in a straight table. Now i want to use this expression in another expression but grouped by a dimension named subdivsion. Help us out in this matter:

expression :   (WareHouseExpense1_Sender*sum(Conversion*[tr_Qty Sold]))/sum(total<WHS_Sender_Key>Conversion*[tr_Qty Sold]))

331 Views
0 Likes
2 Replies
sunny_talwar
MVP
MVP
‎2015-08-31 10:10 AM

Would you be able to share few lines of data?

245 Views
0 Likes
Not applicable
‎2015-08-31 11:51 AM
Author

In response to sunny_talwar

Capture.PNG

Hope this data helps !! Expression i wrote here for warehouse is same as i mentioned in question. Now i want this expression to be grouped by subdivision via total qualifier or aggr if there's a way to do it. When i am using aggr outside of whole expression it is giving null values. Any suggestions would be appreciated.

245 Views
0 Likes