Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count with multiple Conditions

Hi,

I want to calculate how many applications are sanctioned. The criteria is: Sanctioned = Sanctioned-not Booked+Booking Started+Lender Decision for the following data. Can I just use <Case expression> to get the above or would have to must use Appl_ID

APPL_ID<CASE  expression>
19681349ENTERED
19737483DECLINED
11089833Booking Started
11829485BOOKED
13145469DECLINED
10510490DECLINED
15079449BOOKED
16357070BOOKED
17715414Lender Decision
19097166BOOKED
12671357DECLINED
12973150DECLINED
13417909DECLINED
15294770BOOKED
17432881SYSTEM DECISION
13579447BOOKED
19212301Sanctioned-Not Booked
10369751REFERRAL EVENT
15752122BOOKED
14255114DECLINED
10240186DECLINED
19214097Cancelled
15874564BOOKED
12260756DECLINED
11978952BOOKED
15505655Cancelled
11368921BOOKED
11087854Lender Decision
13137807BOOKED
16159271Cancelled
16510501BOOKED
10393592BOOKED
10007616BOOKED
11916336BOOKED
18191506BOOKED
14763573BOOKED
10256936REFERRAL EVENT
18988955BOOKED
13848021DECLINED
17872078BOOKED
16139673BOOKED
16067788Sanctioned-Not Booked


13 Replies
kouroshkarimi
Creator III
Creator III

assuming that <Case expression> is a field name, then try

count({$<[<Case expression>]={'Sanctioned-not Booked','Booking Started','Lender Decision'}>} APPL_ID)

Not applicable
Author

Yes case expression is a field name. Basically I want to show in pie chart % of applications sanctioned (Sanctioned-not booked+Booking started+Lender decision), declined and Booked. Appl_ID is the primary key.

MK_QSL
MVP
MVP

Is this what you are looking for?

Not applicable
Author

Yes,

MK_QSL
MVP
MVP

if you requirement fulfilled, please close this discussion by making correct answer.

Thanks...

Not applicable
Author


I am still looking for the solution because the above formula did not work. Could you please tell how can I draw pie chart as discussed above.

Not applicable
Author

can u please paste the formula becuase unable to download file

MK_QSL
MVP
MVP

1) Select PIE chart

2) Dimension = CASE

3) Expression 1 = COUNT(APPL_ID)

     Tick Value on Data Points

4) Expression 2 = if(Count(DISTINCT CASE)=1, CASE)

     Tick Value on Data Points

5) Presentation Tab

     Untick Show Legend....

Not applicable
Author

Thanks Manish but I need to get total sanctioned applications and the logic should be as below:

Sanctioned = Sanctioned-Not Booked + Booking started + Ledner Decision.

How can I use this logic in the formula to count Sanctioned Not booked, Booking started and Lender decision as one legend