Rewriting a Percentage Expression

[tom2qlik]

Hi All,

Is there an easier way to write this chart expression for converting to percentage?

I would like to know if the set analysis has to be placed by every sum or is there a way to do an overall set analysis and then calculate the percentage.

sum({<Category = {"Reduce"}>}[<10])/
(sum({<Category = {"Reduce"}>}[<10]) + sum({<Category = {"Reduce"}>}[<100])

+ sum({<Category = {"Reduce"}>}[100-1000]) + sum({<Category = {"Reduce"}>}[>1000]))

Thanks

Tom

[kaushiknsolanki]

Hi,

Try this.

sum({<Category = {"Reduce"}>}[<10]/([<10] +[<100]+ [100-1000] + [>1000]))

Regards,

Kaushik Solanki

[hector_munoz · Accepted solution]

Hi Tom,

Try the following:

sum({<Category = {"Reduce"}>} [<10]) / (sum({<Category = {"Reduce"}>} [<10] + [<100] + [100-1000] + [>1000])

Regards,

H

[tom2qlik]

Thanks!