Discussion board where members can get started with QlikView.
Plz can any one give expression for this
yup so second image will work for you.
if at all you want to use it in expression than use:
View solution in original post
where are you displaying it?..
in chart or list box or table box where?
If it is a tablebox check on Omit Null Values here
if it is a chart check on supress null values like this:
I want to display on straight table
Select emp field in the dimension tab and tick suppress when value is null