Discussion board where members can get started with Qlik Sense.
Hi, I have two columns named Object and Address, and I want to edit the script editor to give me results, If Object has an address show me 1, and if the Object doesn't have an address(if its null) show me 0,How can I do that? Thanks in advance!
Ideally something like below must help ,if not please share the data
if(len(trim(address))>0 and isnull(address)<>0,1,0) as Flag
try to use below expression this could be help you
If(GetFieldSelections(object)>1 and Len(Trim(address))<>0,1,0)