Null values and QVD

[qlikviewaf]

Hi Guys,

i'm struggling with my app.

as you can see i have some null-values for the "Item_Category" field - i'm using QVD.

I really don't know how i can manage it in order to filter it on set-analysis.

Any Advise?

Thank you

[qlikviewaf]

for all users - i tested it using Debug and was not working.

Reloading all script is working.

I just used: LOAD If(Len(Trim(Item_Category)) = 0, 'NA', Item_Category) as Item_Category,