topic Re: what does this expression mean? in QlikView

what does this expression mean?

Wed, 25 Nov 2020 16:16:04 GMT

This variable, what does the expression mean?

Thanks!

Re: what does this expression mean?

devarasu07 — Thu, 06 Jul 2017 16:20:52 GMT

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

Re: what does this expression mean?

Anil_Babu_Samineni — Thu, 06 Jul 2017 16:21:30 GMT

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.

Re: what does this expression mean?

Thu, 06 Jul 2017 16:37:04 GMT

Thanks!

Re: what does this expression mean?

Thu, 06 Jul 2017 16:37:09 GMT

Thanks!