Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Show dimension with no expression values

Hi -


I have a straight table that simply is calculating how many sales per employee.  I want to only show employees who haven't had a sale.  There is a null/missing symbol in the Transaction ID field for those who didn't have a sale. 


I've tried unchecking suppress the missing values and checking show all values.  That doesn't work because my employee field includes some who are terminated.  I only want to show active employee with no sales.


Any help would be appreciated.  I have attached a qvw with test data.


Thanks,

Robyn

Tags (4)
1 Solution

Accepted Solutions

Re: Show dimension with no expression values

Hi Robyn, you can add a calculated dimension like:

=Aggr(If(Count([Trans ID])=0, EMPLOYEE), EMPLOYEE)

The table in your sample file is a 'Table Box', not a 'Straight Table'. In table box you can't use calculated dimensions.

If you want to remove inactive employees you need a field that identifies each employee as active or inactive.

2 Replies

Re: Show dimension with no expression values

Hi Robyn, you can add a calculated dimension like:

=Aggr(If(Count([Trans ID])=0, EMPLOYEE), EMPLOYEE)

The table in your sample file is a 'Table Box', not a 'Straight Table'. In table box you can't use calculated dimensions.

If you want to remove inactive employees you need a field that identifies each employee as active or inactive.

Not applicable

Re: Show dimension with no expression values

Thanks Ruben -  This worked perfectly.  I did apply it to a straight table and not the table box.

Community Browser