Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
ecabanas
Contributor

Show only values

Hi all,

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

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

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

Thank's

Tags (1)
1 Solution

Accepted Solutions

Re: Show only values

May be this then:

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

4 Replies

Re: Show only values

May be like this:

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

ecabanas
Contributor

Re: Show only values

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

Re: Show only values

May be this then:

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

ecabanas
Contributor

Re: Show only values

U are the ONE!!

Thank'sssss