I am not formally trained in QlikView but find myself learning as I go.
I have an expression for s straight table that looks like this:
I would like something where I can do this:
Count(Distinct Field1&Field2&Field3) Where Field3 not null
I am looking to get a 0 when Field1 and Field2 still has a row in the table but Field 3 would be null in that row.
Currently Field3 is not included in the straight table as a dimension because that creates a separate row for each entry that is not null in Field3.
Values in all dimensions are strings
I hope this makes sense
Any help you could provide would be appreciated.