Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I having 4 fields:
(1) Name
(2) Address 1
(3) Address2
(4) pOSTAL coDE
I dont want to show the rows in the straight table in qlikview having null or blank rows in Address1 or Postal code ...please suggest.
Name and address are coming from different tables.
under tab Dimension unclick "suppress when value is null"
and under presentation "clikck "suppress Zero values"
that should do it
Go to Chart Properties => Choose Presentation Tab => Choose Address1 from the box named Columns and then Check Suppress Missing and Check Suppress Zero-Values.
Does this help you?
Hi Vir,
If you don't want null values in your application then always it is best practice to remove those null values from script level. You can remove at scripting.
Hope this information helps you.
Regards,
Mahamed.