If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Please assist how can i achieved this,
i want to make a dimension category by calculating the scenario given below.
I have to calculate this on bases of dimension suppose ID - Retailer
The sample is calculating the value against 1 ID with multiple Retailer.
Please suggest how can i calculate this.
The following expression gives the cumulative percentage of total in descending order:
rangesum(below(sum(FieldName), 0, count(total distinct FieldName))) / sum(Total FieldName)