How to show KPI using chart expressions?

[#1]

Hi,

I have Dimension and Expressions as below

Dimension: Name

Expr1:

Count(DISTINCT {<Flag={1},Path={'Banymoore'},Station={'Posted'},MonthYear={"=$(=Date(Addmonths(Max(MonthYear),0)))"}>}ID)

Expr2:

Count(DISTINCT {<Flag={1},Path={'Banymoore'},Station={'Ready to Post'},MonthYear={"=$(=Date(Addmonths(Max(MonthYear),1)))"}>}ID)

I want to show the KPI (with smiley and sad faces). I want to show smile face when Expr1 > 100 and sad face when Expr1 <100. For second expression smile face when Expr2 >50 and sad face when Expr2 <50.

please can anyone suggest me how to do this?

Thanks.

[Gabriel]

Hi,

If you wanted to use those in QlikView already then you don't need to load them in.