including blank in filter selection

Anonymous — Thu, 04 May 2017 20:11:50 GMT

I have a field in which the values are daily and hourly .. and there are some blanks .. i want to show blanks along with the Hourly and Daily values when selected .. here is the condition i am using in the script

if(Len(Trim("metric_breakdown") = 0 or "metric_breakdown"='daily'),'Daily',

if(Len(Trim("metric_breakdown") = 0 or "metric_breakdown"='hourly'),'Hourly')) as [Rum Metric Breakdown],*;

what is that i am doing wrong .. i could only see daily value in my filter

Thanks

Re: including blank in filter selection

vishsaggi — Thu, 04 May 2017 20:15:13 GMT

Try this:

if(Len(Trim("metric_breakdown")) = 0 or "metric_breakdown" = 'daily' ,'Daily',

if(Len(Trim("metric_breakdown")) = 0 or "metric_breakdown" = 'hourly','Hourly')) as [Rum Metric Breakdown]

topic including blank in filter selection in QlikView

including blank in filter selection

Re: including blank in filter selection