Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Dimension limit in a chart object

Hi,

I want to create a pivot table for a specific business unit.

I do not want to limit my business units in my script, as I need all the data for another sheet in my model.

How do I limit the dimension to only look at the specific business unit called WWS?

The pivot table currently gives the WWS seperate from the rest of the BU's , whilst the total pivot table balances to the total sales amount.

See attached a screenshot of my object below

1 Solution

Accepted Solutions
Highlighted

Try this

If(BU = 'WWS', BU)

and then check 'Suppress When Value Is Null' on the dimension tab of the chart properties for the above dimension

Alternatively, you can use set analysis in your expression like this

Sum({<BU = {'WWS'}>} Measure)

View solution in original post

1 Reply
Highlighted

Try this

If(BU = 'WWS', BU)

and then check 'Suppress When Value Is Null' on the dimension tab of the chart properties for the above dimension

Alternatively, you can use set analysis in your expression like this

Sum({<BU = {'WWS'}>} Measure)

View solution in original post