topic Re: IF statement with nothing in else condition. in QlikView

IF statement with nothing in else condition.

Thu, 04 Feb 2016 01:17:05 GMT

I am making a pivot table with one of the dimensions as hour of the day. I want each hour to be shown as a column in the table and I would like the hours to be between 8 and 23 hrs. so i used a calculated dimension with the IF statement saying that if hour >=8 and <=23,hour.I did not put any else condition. It works fine except that there is now a column with a no name. I think it is for those values that satisfy the else condition. I donot want that column to be there in the table. How do I proceed with that?

Thanks.

Re: IF statement with nothing in else condition.

PrashantSangle — Thu, 04 Feb 2016 07:12:42 GMT

Hi,

Check Supress when value is null in Dimension tab.

Or You can create that field in script and use it in your chart.

Regards

Re: IF statement with nothing in else condition.

raman_rastogi — Thu, 04 Feb 2016 07:14:36 GMT

-> You can Check Suppress when value is null in Dimension tab.

Re: IF statement with nothing in else condition.

avinashelite — Thu, 04 Feb 2016 08:16:21 GMT

You can achieve it in 2 ways.

Add a calculated dimension and then check the supress null option in the dimension tab and check the supress null option the presentation tab too.

Add the dimension as it is and in the expression add the condition to filter only the hours you required using the set analysis or if condition this will improve the performance too (check the supress null option in the presentation tab)

Re: IF statement with nothing in else condition.

Thu, 04 Feb 2016 14:22:15 GMT

ohh my bad! missed out on such a small thing. It worked.Thanks!