topic Re: Count value based on Condition in front end in QlikView

Count value based on Condition in front end

Wed, 03 Sep 2014 12:07:56 GMT

Hi All,

I have 4 Fields like Cust Id,Sale,Target,Month

then i calculated the percentage of (sale/target)*100 for each month

Now i need the Cust Id's with count of months those are having Percentage more than 60%.

output like:

sample Data:

sundarakumar — Wed, 03 Sep 2014 12:21:04 GMT

PFA the application with the requirement completed on the attached sample. (Straight table as mentioned)

Thanks

Sundar

maxgro — Wed, 03 Sep 2014 12:33:56 GMT

in a straight table chart with custid as dim use the expression

count(distinct

if(aggr(sum(Sale)/sum(Target), Month,Custid)>0.6,Month)

)