Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

apalmtree
Contributor

hide dimensions due to possible fileds(?)

Hi,

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!

//A.

6 Replies
Not applicable

Re: hide dimensions due to possible fileds(?)

Do you have a sample file with fake data?

whiteline
Honored Contributor II

Re: hide dimensions due to possible fileds(?)

Coul you just provide your calculation dimension expression ?

apalmtree
Contributor

Re: hide dimensions due to possible fileds(?)

=Department&'-'&employment&'-'&Gender

whiteline
Honored Contributor II

Re: hide dimensions due to possible fileds(?)

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.

apalmtree
Contributor

Re: hide dimensions due to possible fileds(?)

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.

whiteline
Honored Contributor II

Re: hide dimensions due to possible fileds(?)

I guess your data is more complex than I've used.

Do you have all fields in one table ?

Try this:

=aggr(if(aggr(nodistinct count(distinct employment & Gender), Department) = 4, Department & employment & Gender), Department, employment, Gender)

Community Browser