topic Re: Percentage based on another straight table column in QlikView

Percentage based on another straight table column

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

I want to work out the percentage per brand in a straight table. Not quite sure the best way to go about calculating the percentage column. Any ideas most welcome.

Example

Last Page	Brand	Brand Count	Percentage
Basic	BR	10	6.25
Standard	BR	30	18.75
Bulletin	BR	120	75
Basic	CAM	65	19.12
Standard	CAM	250	73.53
Bulletin	CAM	25	7.35

Re: Percentage based on another straight table column

sunny_talwar — Tue, 08 Mar 2016 13:40:27 GMT

May be this:

Count([Brand Count])/Count(TOTAL <Brand> [Brand Count])

Re: Percentage based on another straight table column

haymarketpaul — Tue, 08 Mar 2016 13:51:21 GMT

Thanks for reply - that seems to make the %age column NULL ?

I've attached my qvw

Re: Percentage based on another straight table column

sunny_talwar — Tue, 08 Mar 2016 13:58:47 GMT

Try this expression:

=Count(UserID)/Count(TOTAL <Brand> UserID)

Re: Percentage based on another straight table column

haymarketpaul — Tue, 08 Mar 2016 14:04:50 GMT

Perfect - Thank you