topic how to remove ? and null values in report ? in QlikView

how to remove ? and null values in report ?

Wed, 21 May 2014 07:11:24 GMT

how to remove ? and null values in report ?

ramasaisaksoft — Wed, 21 May 2014 12:42:30 GMT

Hi Manoj,

if u want remove "Null " values from a particular column ,you can do this in Script like below

Load sal,eno from fact_Reservation;

sql select * from fact_Reservation where eno<>'NULL';

sql select * from fact_Reservation where eno<>NULL;

please check like this may be it will helpful to u

Anonymous — Wed, 21 May 2014 12:49:13 GMT

Check on the suppress When Value is Null..

In Dimension

ramasaisaksoft — Thu, 22 May 2014 04:12:03 GMT

Hi Sreekanth ,

i Hope u r asking in code.Any way thanks for u r reply.I hope u r a Telugu person am i wright?if yes reply to me

ramasaisaksoft — Thu, 22 May 2014 04:15:29 GMT

This solution only applicable for Chart.

But my solution in code is applicable for all sheet objects('Null' values are filter in Listbox,Tables ....etc)

vardhancse — Thu, 22 May 2014 06:10:55 GMT

Hi,

If we want to remove null values from all the fields, then we should mention and condition in the where condition.

Is there any alternate for this.?

Thu, 22 May 2014 06:47:52 GMT

s mail is manojkumar27.m@gmail.com in mumbai present

anbu1984 — Thu, 22 May 2014 06:52:00 GMT

In Sql

sql select * from fact_Reservation where eno Is Not NULL;