Hidden document in categorised columns

HiI have a view embedded in a page with Show single category and a use @Name([CN];@UserName).

First column in that view i use three fieldvalues (nameField1, nameField2, nameField3). If your name are in one ore more of these fields you vill se the document categorised with your name.

To display the document i use

tmp1 := @If(nameField1=“”;“No value”;nameField1);

tmp2 := @If(nameField2=“”;“No value”;nameField2);

tmp3 := @If(nameField3=“”;“No value”;nameField3);

tmp1:tmp2:tmp3

The problem is that when i categorise the view a get the document more then once. It´s show up first categorised with your name and then categorised with No value. Thats because some of the value is empty.

Is there anyway to hidden the category who return No value

Kind regards

Fredrik

Subject: try this

tmp1 := @If(nameField1=“”;“”;nameField1);tmp2 := @If(nameField2=“”;“”;nameField2);

tmp3 := @If(nameField3=“”;“”;nameField3);

ret:= @Trim(tmp1:tmp2:tmp3);

@If(ret=“”;“No Value”;“”)