Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ajaykumar1
Creator III
Creator III

% calculation(:-)

Hi all,

I have a small req. how we can do this.

                    value               Percentage

                   100                    Logic is 100/1000= 10%

                    300                     300/1000=

                    500                      same 

                    100                      same

               Total 1000        

                    

if in set analysis it might very usefull to learn me.

Thanks ,

Ajay

1 Solution

Accepted Solutions
Anonymous
Not applicable

Ajay

Try something like the attached.

Best Regards, Bill

View solution in original post

7 Replies
Nicole-Smith

sum(Value)/sum(total Value)

Anonymous
Not applicable

Ajay

Try something like the attached.

Best Regards, Bill

ajaykumar1
Creator III
Creator III
Author

Thanx Bill.....but user dont want 3 expressions....

Not applicable

Hi Ajay,

Chart Properties, Expressions Enable the Relative check Box. Or try this your expressions Sum(Sales)/Sum(TOTAL(Sales))

Nicole-Smith

You can do it in one expression right like I have written above.

Anonymous
Not applicable

Ajay

If you don't want one of the expressions, then simply delete it.

You probably don't want the one called 'Sum Value', I just put it there to help you understand how it worked, but it seems as if it just confused you.

Best Regards,     Bill

ajaykumar1
Creator III
Creator III
Author

Thanks Nicole ,Bill and Raja...Its working.

Thanks Bill for your time more given clarity.

Ajay