Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Multiple field count - Conditional

I have 2 problems here connected.  The first problem is that my expression results show as '-1' so they do not count (but still display the correct fields

My second dilema is that I want to merge my expression to display a chart with all the data in one place..

The problem I have is that I have 2 conditions that I need to apply over 2 fields, which compounds the complexity.

1st condition

 

Count({$<[StartDate]={'In Process'}>} [StartDate])

and

count({$<[ReferenceID]-={''}>} [ReferenceID])

The above will count and field which has 'In Process' and where there is no ReferenceID

2nd Condition

 

Count({$<[StartDate]-={'In Process'}>} [StartDate])

and

count({$<
[ReferenceID]={''}>} [ReferenceID])

This one will count any field which has a start date, but does not have a reference number.

Both of these work in isolation (2 seperate Charts), but I do not know how to put them together to get a full set of data.

Any help appreciated

Phil

0 Replies