topic Rewriting a Percentage Expression in QlikView

Rewriting a Percentage Expression

tom2qlik — Fri, 30 Jun 2017 10:37:21 GMT

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

Re: Rewriting a Percentage Expression

kaushiknsolanki — Fri, 30 Jun 2017 10:45:49 GMT

Hi,

Try this.

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

Regards,

Kaushik Solanki

Re: Rewriting a Percentage Expression

hector_munoz — Fri, 30 Jun 2017 11:04:37 GMT

Hi Tom,

Try the following:

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

Regards,

Re: Rewriting a Percentage Expression

tom2qlik — Fri, 30 Jun 2017 13:55:24 GMT

Thanks!