Discussion board where members can get started with QlikView.
i am getting nulls from Database only
but i want to exclude nulls from DB while loading itself how can i do this in script? you can see in image with empty spaces i dont want that
Give a try as below:
WHERE Len(Trim(Deal_Type)) > 0
you can use also:
Where not isnull(Field);