topic Re: Count total divide by value in QlikView

Count total divide by value

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

What would be the best approach for what I'm looking for, script or expression?

I have a pivot chart, below.

I need to count the total PK then divide by when Reason = Yes

End goal:

% of Reasons from total PK counts.

Example

Count of PK - 100

Count of Reason - 25

25/100 = 25%

----------------------------------------------------------------

COUNTY YEAR 2016 2015 2014

Singleton

Parry

Luck

Luke

Values

Year

County

Reason

Re: Count total divide by value

sunny_talwar — Thu, 29 Sep 2016 13:19:47 GMT

Not sure I understand

Count(PK)/Count(Reason)?

Re: Count total divide by value

Thu, 29 Sep 2016 13:23:21 GMT

I'm having trouble following your example but I'll give it a shot. I'm going on the assumption that you are looking for a pivot table with two dimensions COUNTY and YEAR and you need a expression that is count of PK over Count of Reason where reason = Yes.

your expression would be

COUNT(PK)/SUM(IF(Reason='Yes',1,0))

If I'm not following right please post an excel or QVW that demonstrates what you want. Even if the results are wrong it will help color a picture and you can point out where it is wrong.

Re: Count total divide by value

Anonymous — Thu, 29 Sep 2016 13:42:18 GMT

Yes, simple enough.

count({<REASON = {'Yes'}>}PK)/count(PK)