topic Re: Calculating the sum for each condition in pie chart in QlikView

Calculating the sum for each condition in pie chart

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

I want to put a pie chart where it has to show count of lender_offer_id for particular client who has scored less than 80% , between 80%-90% and exactly 100%.

You could refer attached database file.Please help me on this.

Re: Calculating the sum for each condition in pie chart

varshavig12 — Fri, 17 Jun 2016 11:47:22 GMT

Chart type:

Pie

Calculated dimension:

=if(completion_percentage<80,'less than 80',

if(completion_percentage=80 or completion_percentage<100 ,'80-99',

'100'))

expression:

count( lender_offer_id)

Re: Calculating the sum for each condition in pie chart

berryandcherry6 — Fri, 17 Jun 2016 12:30:40 GMT

Hi varshavig12 ,

Thanks for your reply

I need to put condition for particular client _id also ,where could i put that condition in above codde?