topic Count If Set Expression / Count total expression in QlikView

Count If Set Expression / Count total expression

Wed, 05 Aug 2015 15:48:27 GMT

Hi All,

I have the following expression:

if(sum({<Week_Commencing = {'$(vMaxDate)'}>} [ABC]) <= 1 , count({<Week_Commencing = {'$(vMaxDate)'}>} [Ship-to Code]))

Which when used in a straight table with product as a dimension gives me the count of ship-to that have an ABC less than or equal to 1.

What I then want to do is calculate this as a % of total, which also in a straight table is:

sum({<Week_Commencing = {'$(vMaxDate)'}>} [ABC])

However, clearly I need this as count of the number of ship-to's

So... what I am trying to get to is the count of ship-to's with an ABC less than or equal to 1 as a percentage of the total count of ship-to's in a straight table with product as a dimension.

Sorry if this isn't very clear!

Thanks folks

Re: Count If Set Expression / Count total expression

Qrishna — Wed, 05 Aug 2015 15:50:41 GMT

please share a sample.

may be like this,but not sure without seeing the data:

if(sum({<Week_Commencing = {'$(vMaxDate)'}>} [ABC]) <= 1 ,

count({<Week_Commencing = {'$(vMaxDate)'}>} [Ship-to Code])) /

count( total {<Week_Commencing = {'$(vMaxDate)'}>} [Ship-to Code])

and format the output with num() function according to the requirement.

Re: Count If Set Expression / Count total expression

sasiparupudi1 — Wed, 05 Aug 2015 18:39:47 GMT

please post your application