topic Null values getting in QlikView

Null values getting

ravindraa — Tue, 16 Sep 2014 09:37:39 GMT

hi i have one requierment i need to get only when customer is equal to zero.
The customer field have below value like

Customer

<- this is the null value

L
C

<- this is the null value

To get the Values based on the condition like below

in the edit script level i wrote below conditon

Customer:

Load
customer,
Id where match(customer,' ');

sql from customer;

Please give any suggesion one this.
Thanks for advance.

MK_QSL — Tue, 16 Sep 2014 09:47:27 GMT

Load * Inline

[

Customer, Sales

, 100

L, 120

C, 140

, 200

] Where IsNull(Customer) or Len(Trim(Customer))= 0;

MayilVahanan — Tue, 16 Sep 2014 10:00:54 GMT

Try like this

Customer:

Load
customer,
Id where Len(Trim(customer)) =0;

sql select * from customer;

ravindraa — Tue, 16 Sep 2014 11:45:29 GMT

Thank you very much Manish Kachhia.

it is working fine.

ravindraa — Tue, 16 Sep 2014 11:45:55 GMT

Thank you very much Mayil Vahana Ramasamy,
it is working fine.