topic Re: Show dimension with no expression values in QlikView

Show dimension with no expression values

Thu, 29 Jan 2015 15:17:25 GMT

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

Re: Show dimension with no expression values

rubenmarin — Thu, 29 Jan 2015 15:32:30 GMT

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.

Re: Show dimension with no expression values

Thu, 29 Jan 2015 16:06:07 GMT

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