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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to compute exclusive % with out using Row ?

Hi All

From HIC blog have show us the inclusive % using below expression :-

RangeSum(Above(Sum(sales), 0, RowNo())) / Sum(total sales)

I need to replace with , because if using row , it will not allow me sort sales col from hi to lo:-

Sum(sales)/Sum(TOTAL(sales))

For Exclusive % using below expression :-

RangeSum(Above(Sum(sales), 1, RowNo())) / Sum(total sales)

I like to ask , how to replace the above with out using row ?

Paul

0 Replies