topic Re: percentage calculation in QlikView

percentage calculation

buzzy996 — Wed, 16 Mar 2016 15:35:45 GMT

hi,

my dimensions are

1.Name

2. calculated dimension is "=If(Networkdays(Scheduled_Send_Time__c,Delivery_Acknowledged_Time__c,$(ListOfHolydays))>=6,'SLAs Not Met','SLAs Met')"

and expression is--> =Count(IP_No__c) ,So I'm getting the below screen results.

Expected values/output are: Instituted of numbers I need percentages for example first dimension in above chart shows "73,754 and 1784" for the same expected out is "97.63% and 2.36%"

any help?

thanks

Re: percentage calculation

sunny_talwar — Wed, 16 Mar 2016 15:37:21 GMT

Have you tried selecting relative?

Re: percentage calculation

ali_hijazi — Wed, 16 Mar 2016 15:38:30 GMT

Count(IP_No__c) / count(Total IP_No__c)

Re: percentage calculation

jagan — Wed, 16 Mar 2016 15:47:49 GMT

HI,

Try like this

=Count(IP_No__c) / Count(TOTAL IP_No__c)

Or select relative option.

Regards,

Jagan.

Re: percentage calculation

buzzy996 — Wed, 16 Mar 2016 16:04:38 GMT

hi Sunny/Jagan,

i tried both by applying Relative or ount(IP_No__c) / Count(TOTAL IP_No__c) geting the belwo result.

the problem with above chart is the percentages are calculating with respect to all the dimensions("corp,nphoe....,ent AG,mhope" equalizes to 100%),my case each dimension is equalizes to 100%(for example the first dimension corp is one dimension combination of sla met & not met)

any help?

thanks

Re: percentage calculation

jonathandienst — Wed, 16 Mar 2016 16:09:22 GMT

Qualify the total with Name, like this

Count(IP_No__c) / count(Total <Name> IP_No__c)

Re: percentage calculation

Digvijay_Singh — Wed, 16 Mar 2016 16:09:33 GMT

Your legend is showing some error, could you see why its showing error? You didn't mention in problem so I thought may be missed in checking that.

Re: percentage calculation

buzzy996 — Wed, 16 Mar 2016 16:19:08 GMT

Thanks Jonathan.

Thank you all

Re: percentage calculation

avinashelite — Wed, 16 Mar 2016 16:20:43 GMT

if you want the total according to one of the dimension values ...then use the TOTAL key word along with the expression

like count(ID)/count(distinct TOTAL<dimension1>ID)

Re: percentage calculation

buzzy996 — Wed, 16 Mar 2016 16:31:53 GMT

hi guys,

i 've to include avg line by considering only sla met cases.

can help some one?

thanks

Re: percentage calculation

jonathandienst — Thu, 17 Mar 2016 09:50:41 GMT

I suggest that you open a new thread for this question. Explain what you require in a little more detail - the question is a little vague. If you need to, you can reference this discussion in your post. And as always, it is best if your requirement can be illustrated by examples.