topic Re: A calculated dimension which ignores user selection in QlikView

A calculated dimension which ignores user selection

dafnis14 — Thu, 20 Nov 2014 06:37:29 GMT

Hi,

I would like to create a table with a dimension that ignores a specific selection of other linked dimension.

For example:

The calculated dimension is Product.

The selected dimension to ignore is Warehouse Type.

So the table has to show all the products, regardless of the selected warehouse type.

Unfortunately, I couldn’t find solutions in previous posts.

Thanks!

ashfaq_haseeb — Thu, 20 Nov 2014 06:42:21 GMT

Hi,

Can you attach sample data

Regards

ASHFAQ

MarcoWedel — Thu, 20 Nov 2014 07:02:39 GMT

=aggr(only({$<[WarehouseType]=>} Product), Product)

dafnis14 — Thu, 20 Nov 2014 07:34:21 GMT

Thanks!

MarcoWedel — Thu, 20 Nov 2014 08:50:03 GMT

You're welcome

regards

Marco