Show only values

[ecabanas]

Hi all,

I have this chart with itemid as a dimension and Tarifa with this if(isnull((Tarifa)),'Tarifa No Informada','')

ItemId	Tarifa
10356755
10356756
10356785	Tarifa No Informada
10356786	Tarifa No Informada
10356794
10356796
10356797	Tarifa No Informada
10356799
10356819
10356823
10356825
10356828
10356834	Tarifa No Informada
10356835	Tarifa No Informada
10356836	Tarifa No Informada
10356843	Tarifa No Informada
10356844	Tarifa No Informada

The problem is I only want to show the itemsid with "Tarifa No Informada"

Thank's

[sunny_talwar]

May be like this:

If(Len(Trim(Tarifa)) > 0, Tarifa)

[ecabanas]

Hi Sunny,

Many thank's but I looking for a Chart that shows only the items without Price(Tarifa) , this expression shows the items how has price

Many thank's

[sunny_talwar · Accepted solution]

May be this then:

If(Len(Trim(Tarifa)) = 0, 'Tarifa No Informada')

[ecabanas]

U are the ONE!!

Thank'sssss