Discussion board where members can get started with Qlik Sense.
From my qvd I load many customers. Some of the customers have a number, others not. I want to show in my chart if a customer has this number, with a "Yes".
Load from QVD:
I want to show:
I hope this is possible.
thanks a lot!
Go to Solution.
if(Len(NUmber)>0,'Yes','No') as Number
let me know
It can also be done using
if(isnull(Number),'No','Yes') as Number