Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
berndjaegle
Creator II
Creator II

Set Analysis only completed bills

Hi guys,

I am looking for the correct set anlaysis.

Only completed bills should be calculated and shown.

When ALL of them Status= done, then sum(Faktura).

Example: only BillingNo 101 should be shown.

completed_bills.png

This intersection doesn't work:

sum({$ Status = {'done'} >*< Status={'open', 'in progress', 'done'} >} Faktura)

Can you help me?

 

1 Solution

Accepted Solutions
jwjackso
Specialist II
Specialist II

Try excluding BillingNo where there is a status other than 'done'.

sum({<BillingNo=E({<Status-={'done'}>}BillingNo)>}Faktura)

View solution in original post

1 Reply
jwjackso
Specialist II
Specialist II

Try excluding BillingNo where there is a status other than 'done'.

sum({<BillingNo=E({<Status-={'done'}>}BillingNo)>}Faktura)

View solution in original post