topic Re: Show only values in QlikView https://community.qlik.com/t5/QlikView/Show-only-values/m-p/1193552#M385336 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P><STRONG>If(Len(Trim(Tarifa)) &gt; 0, Tarifa)</STRONG></P></BODY></HTML> Thu, 29 Sep 2016 13:27:54 GMT sunny_talwar 2016-09-29T13:27:54Z Show only values https://community.qlik.com/t5/QlikView/Show-only-values/m-p/1193551#M385335 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have this chart with itemid as a dimension and Tarifa with this<SPAN style="color: #0000ff;"> </SPAN><SPAN style="color: #0000ff; font-size: 10pt;">if(isnull((Tarifa)),'Tarifa No Informada','')</SPAN></P><TABLE><TBODY><TR><TD>ItemId</TD><TD>Tarifa</TD></TR><TR><TD>10356755</TD><TD></TD></TR><TR><TD>10356756</TD><TD></TD></TR><TR><TD>10356785</TD><TD>Tarifa No Informada</TD></TR><TR><TD>10356786</TD><TD>Tarifa No Informada</TD></TR><TR><TD>10356794</TD><TD></TD></TR><TR><TD>10356796</TD><TD></TD></TR><TR><TD>10356797</TD><TD>Tarifa No Informada</TD></TR><TR><TD>10356799</TD><TD></TD></TR><TR><TD>10356819</TD><TD></TD></TR><TR><TD>10356823</TD><TD></TD></TR><TR><TD>10356825</TD><TD></TD></TR><TR><TD>10356828</TD><TD></TD></TR><TR><TD>10356834</TD><TD>Tarifa No Informada</TD></TR><TR><TD>10356835</TD><TD>Tarifa No Informada</TD></TR><TR><TD>10356836</TD><TD>Tarifa No Informada</TD></TR><TR><TD>10356843</TD><TD>Tarifa No Informada</TD></TR><TR><TD>10356844</TD><TD>Tarifa No Informada</TD></TR></TBODY></TABLE><P></P><P>The problem is I only want to show the itemsid with "Tarifa No Informada"</P><P></P><P>Thank's</P></BODY></HTML> Thu, 29 Sep 2016 13:25:57 GMT https://community.qlik.com/t5/QlikView/Show-only-values/m-p/1193551#M385335 ecabanas 2016-09-29T13:25:57Z Re: Show only values https://community.qlik.com/t5/QlikView/Show-only-values/m-p/1193552#M385336 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P><STRONG>If(Len(Trim(Tarifa)) &gt; 0, Tarifa)</STRONG></P></BODY></HTML> Thu, 29 Sep 2016 13:27:54 GMT https://community.qlik.com/t5/QlikView/Show-only-values/m-p/1193552#M385336 sunny_talwar 2016-09-29T13:27:54Z Re: Show only values https://community.qlik.com/t5/QlikView/Show-only-values/m-p/1193553#M385337 <HTML><HEAD></HEAD><BODY><P>Hi Sunny,</P><P></P><P>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</P><P></P><P>Many thank's</P></BODY></HTML> Thu, 29 Sep 2016 13:35:29 GMT https://community.qlik.com/t5/QlikView/Show-only-values/m-p/1193553#M385337 ecabanas 2016-09-29T13:35:29Z Re: Show only values https://community.qlik.com/t5/QlikView/Show-only-values/m-p/1193554#M385338 <HTML><HEAD></HEAD><BODY><P>May be this then:</P><P></P><P><STRONG>If(Len(Trim(Tarifa)) = 0, 'Tarifa No Informada')</STRONG></P></BODY></HTML> Thu, 29 Sep 2016 13:38:10 GMT https://community.qlik.com/t5/QlikView/Show-only-values/m-p/1193554#M385338 sunny_talwar 2016-09-29T13:38:10Z Re: Show only values https://community.qlik.com/t5/QlikView/Show-only-values/m-p/1193555#M385339 <HTML><HEAD></HEAD><BODY><P>U are the ONE!!</P><P></P><P>Thank'sssss</P></BODY></HTML> Thu, 29 Sep 2016 13:48:20 GMT https://community.qlik.com/t5/QlikView/Show-only-values/m-p/1193555#M385339 ecabanas 2016-09-29T13:48:20Z