Dimension values

[priyarane]

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

[maxgro · Accepted solution]

try in a chart with Country as dimension and this esxpression

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

[qlikview979]

Hi   priya,

Try This

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

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