Multiple field count - Conditional

Anonymous — Fri, 12 Jul 2013 08:16:20 GMT

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

topic Multiple field count - Conditional in QlikView

Multiple field count - Conditional