Discussion Board for collaboration related to Creating Analytics for QlikView.
How to count the number of ranches in which there document.2 ?
Try this expression
= count(DISTINCT aggr(count( if(document<>'document2', branch)),branch))
removed DISTINCT inside aggr, just try it.
Pls. see attachement
View solution in original post
A Straight Table with :
Will give the count of ranches for each document.
You can select document2 if that is the only one you wish to see.
see the additional table in the attached.
It is not exactly
May be like this,
Hope this helps,
I'm looking for the number of branches that do not have a document 2
Can you explain a bit more ! Your output required.
try this Expression for Branches that do not have Document 2
= count(DISTINCT aggr(count(DISTINCT if(document<>'document2', branch)),branch))
Please find the attachment
Ha, that's not what you asked for though