what does this expression mean?

[#1]

This variable, what does the expression mean?

Thanks!

[devarasu07]

Hi,

It means if PS_Product is not equal to Null / blank then it will return as 1 else 0. Tks

also you write below way,

if(IsNull(PS_Product),1,0)

IsNull - script and chart function ‒ Qlik Sense

[Anil_Babu_Samineni · Accepted solution]

I would suggest you to buy the Cookbook. This book available in Amazon

For your Question, The answer is If PS_Product is not a null or space values we need to show 1 or else 0. This is good practice to use Flag. And for ref. we can use Set analysis like Customer want to show only Null values then we can use 0 in set analysis.

[#4]

Thanks!

[#5]

Thanks!