Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
berryandcherry6
Creator II
Creator II

Calculating the sum for each condition in pie chart

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.

2 Replies
varshavig12
Specialist
Specialist

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)

berryandcherry6
Creator II
Creator II
Author

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?