Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a chart where i've combined 3 fields as a dimension
Department - employment - Gender
So in the chart the department will show 4 times if all combinations exsist (2 for gender, and 2 for employment)
But in the cases where department's only showing less than 4 times i don't want any of those deparment combinations to be shown at all. Is this possible?
Thanks in advance!
Do you have a sample file with fake data?
Coul you just provide your calculation dimension expression ?
As an example you can use something like this:
=aggr(if(aggr(nodistinct count(Department), Department) = 4, Department&'-'&employment&'-'&Gender), Department, employment, Gender)
It checks if there are four Department instances.
You could check employment and Gender instead, but it's a bit more complex.
Ah aggr, why didn't i think of that. Thanks!
But I only get a '-' in my dimension when trying this. so no dimension basically.
I guess your data is more complex than I've used.
Do you have all fields in one table ?
=aggr(if(aggr(nodistinct count(distinct employment & Gender), Department) = 4, Department & employment & Gender), Department, employment, Gender)