Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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?