how to show the value on data point for one specific country

[sr_qlikview]

Bar Chart > Country vs sum(sales) - how do you show the value on data point for one specific country ignoring other values display (ex: USA) ?

[MayilVahanan · Accepted solution]

HI

In expression tab, ->'+' -> show value

in that, if(Country = 'USA',1,0)

Then untick the values on data point.

[#3]

Create flag in the ETL

IF(Country='ABC',1,0) as Country_Flag

Then in create two expressions

1st:

=

SUm({<Country_Flag={1}>} Sales)

2nd : 

=

SUm({<Country_Flag={0}>} Sales)

Then for the 1st expression show value on the data point

Good Luck..!!