Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Some one help me how to avoid null values in qlikview and
What is the use of Suppress Zero Values?
Where Can we using Suppress Zero Values ?
Some one help me This Scenario
Thanks In Advance
Niranjan
You can remove null values when you do the load by using a where statement (ex. where len(fields >0); ).
The suppress zeros are useful when you don't like to show zeros in your chart for some reason. Activate it will make the chart ignore null and zero values.
You can remove null values when you do the load by using a where statement (ex. where len(fields >0); ).
The suppress zeros are useful when you don't like to show zeros in your chart for some reason. Activate it will make the chart ignore null and zero values.
Hi Hampus ,
Thanks for giving valuable information
Regards,
Niranjan
Suppress Zero values if not enabled, Then the chart will show the zeros values in the data. If you ont want to display the zero values in your table/chart then just Enable Suppress zero values and all the zero values values in your table will not be displayed
Script side how to write expression to avoid Null values
Hi,
as @Hampus Andersson said, like this:
load Field1, Field2 resident Table
where len(Field1)>0;
Hi BBI,
now i am under stand how to use that
Thanks
Niranjan