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
Write Table now available in Qlik Cloud Analytics: Read Blog
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: 
nimeshpa
Partner - Contributor III
Partner - Contributor III
‎2013-11-21 04:31 PM

Calculated dimension + AGGR

Is it possible to use an expression as calculated dimension when expression itself was calculated using AGGR as dimension. I want to use Decile as calculated dimension for further analysis. Expression behind the decile is  ( I have attached the application for reference)

10-(div(((RangeSum(above(TOTAL sum(OrderCount),0,RowNo(TOTAL))))/sum(TOTAL OrderCount))*9.99999999999,1))

Can you help me create 'Decile' from this application as calculated dimension? Thanks.

ABC.qvw
442 Views
0 Likes
0 Replies