Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Valued Contributor

Dimension values

Hi Community,

I have one dimension and measure and I wanted to see always some values from dimension.

For Ex.

Dim: Country, Measure: sales

Country

India

US

China

Australia

and if I select US then it should show US + India

so if I select what ever country then it always show India

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Dimension values

try in a chart with Country as dimension and this esxpression

sum({$ <Country+={India}>} Sales)

View solution in original post

2 Replies
Highlighted
MVP
MVP

Re: Dimension values

try in a chart with Country as dimension and this esxpression

sum({$ <Country+={India}>} Sales)

View solution in original post

Highlighted
Valued Contributor

Re: Dimension values

Hi   priya,

Try This

sum({<country+={India}>}Sales)       It Shows India+US.

sum({<country={India}>}Sales)        It Shows India only.