QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Rules, plus terms and conditions, can be found here.
Not applicable

Limit dimension in table

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?

Jan

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: Limit dimension in table

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.

4 Replies
Not applicable

Re: Limit dimension in table

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.

Not applicable

Re: Limit dimension in table

Hi Jonathan

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

Not applicable

Re: Limit dimension in table

Brilliant! Thank you!

Not applicable

Re: Limit dimension in table

Jan,

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

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

Regards!