topic Re: Limit dimension in table in QlikView

Limit dimension in table

Fri, 17 Oct 2014 12:56:17 GMT

Hi experts

I have the folowing prpblem:

I created a table. The dimension is Business Unit. With the formula I sum up the sales. I have 2 Units, Unit 1 and Unit 2.

How can I restrict the Dimension that only Unit 1 is displayed in the table?

Thank you for your help!

Jan

Fri, 17 Oct 2014 12:59:38 GMT

in the set analysis expression, do something like : =sum({$< [Business Unit] = {'Unit 1'} >} Sales)

Hope it helps!

If this is what you looking for, remember to mark as answered!

Best regards!

Jonathan.

Fri, 17 Oct 2014 13:24:09 GMT

Hi Jonathan

This is my Formula: Sum ({<Year={$(VmaxYear)}>} ([Sales]))

Can I add another selection?

Fri, 17 Oct 2014 13:32:36 GMT

Brilliant! Thank you!

Fri, 17 Oct 2014 13:34:25 GMT

Jan,

Yes you can, i guess you already do it but there you have:

Sum ({<Year={$(VmaxYear)}, [Business Unit] = {'Unit 1'} >} ([Sales]))

Regards!