Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
ecabanas
Creator II
Creator II

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

1 Solution

Accepted Solutions
sunny_talwar

May be this then:

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

View solution in original post

4 Replies
sunny_talwar

May be like this:

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

ecabanas
Creator II
Creator II
Author

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

May be this then:

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

ecabanas
Creator II
Creator II
Author

U are the ONE!!

Thank'sssss