Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Rewriting a Percentage Expression

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

1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

Hi Tom,

Try the following:

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

Regards,

H

View solution in original post

3 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Hi,

Try this.

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


Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
Specialist
Specialist

Hi Tom,

Try the following:

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

Regards,

H

View solution in original post

Highlighted
Creator
Creator

Thanks!