Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
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?

Thank you for your help!

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]))

Can I add another selection?

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!

Community Browser