Qlik Community

Qlik Sense App Development

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

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Luminary
Luminary

limit a table dimension

good afternoon,

I have a table that uses 2 dimensions and a number of measures.  Dimension 2 ('Event') only has 2 values, and I want to create 2 independent versions of the table that are specific to the 2 values.  how can I limit the dimension to bring back only those 2 values?

1 Solution

Accepted Solutions
Not applicable

Re: limit a table dimension

Hi

You can use set analysis in your expressions. Something like this

Tabel1

Sum({<DIM1={'VAL1'}>} Field1)

Sum({<DIM1={'VAL1'}>} Field2)

Table2

Sum({<DIM1={'VAL2'}>} Field1)

Sum({<DIM1={'VAL2'}>} Field2)

1 Reply
Not applicable

Re: limit a table dimension

Hi

You can use set analysis in your expressions. Something like this

Tabel1

Sum({<DIM1={'VAL1'}>} Field1)

Sum({<DIM1={'VAL1'}>} Field2)

Table2

Sum({<DIM1={'VAL2'}>} Field1)

Sum({<DIM1={'VAL2'}>} Field2)

Community Browser