Hi All,
I have data with a include classname and ID mean String and Number.
I seperated Both string and ID.
Right(String, len(String)-index(String,'-',4)) As Employee_Type
I created a Bar chart,
Dimension : Employee_Type
Expresion : Count(ID)
But in Employee_Type having some NULL value.
I have written If(len(Employee_Type)=0,'NULL',Employee_Type)
it is showing NULL in my char.
But Now i don't want the NULLs in my chat i want to suppress.
i enabled CharProperties--->Presentation------> Suppress Zero Value
But still it is showing NULL in my chart is there any way to suppress NULL when we load into Qlikview.
Please let me know.
Thanks
