topic % calculation(:-) in QlikView

% calculation(:-)

ajaykumar1 — Thu, 02 Jan 2014 16:56:31 GMT

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

Re: % calculation(:-)

Nicole-Smith — Thu, 02 Jan 2014 17:03:13 GMT

sum(Value)/sum(total Value)

Re: % calculation(:-)

Anonymous — Thu, 02 Jan 2014 17:03:25 GMT

Ajay

Try something like the attached.

Best Regards, Bill

Re: % calculation(:-)

ajaykumar1 — Thu, 02 Jan 2014 17:06:20 GMT

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

Re: % calculation(:-)

Thu, 02 Jan 2014 17:06:44 GMT

Hi Ajay,

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

Re: % calculation(:-)

Nicole-Smith — Thu, 02 Jan 2014 17:07:01 GMT

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

Re: % calculation(:-)

Anonymous — Thu, 02 Jan 2014 17:11:10 GMT

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

Re: % calculation(:-)

ajaykumar1 — Thu, 02 Jan 2014 17:24:08 GMT

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

Thanks Bill for your time more given clarity.

Ajay