topic Re: Show performance in pivot table in QlikView

Show performance in pivot table

Anonymous — Thu, 14 Feb 2013 09:53:49 GMT

Hello,

I have to show the performance of successful offers made up by the sales department: I'd like to show, for each customer, the number of successful and unsuccessful offers and their incidence on the total of offers quoted to him.

I use a pivot table with the customer's name and the type of offer (successful and unsuccessful) in dimension, and the Count (Distinct (OfferID)) in expression, but I'm not able to calculate the percentage incidence of each one (successful and unsuccessful) on the total of each customer.

Could anybody help me, please?

Thanks.

Nick.

Re: Show performance in pivot table

Thu, 14 Feb 2013 11:18:54 GMT

Hi,

try filtering for succesful and unsuccesful.

Expression for succesful could be:

Count (Distinct {$<[type of offer] = {'Succesful'}>} (OfferID)) / Count (Distinct (OfferID))

and in Number Properties check the Setting (Integer) and then check "Show in percent %"

Hope it helps

regards

Giampiero

Re: Show performance in pivot table

Anonymous — Thu, 14 Feb 2013 13:08:44 GMT

Yea! It works properly!

Thank you very much.

Nick.