Solved: Re: How to write the expression - Qlik Community

suvechha_b · ‎2015-10-05

How to write the following in qlikview expression:

if NettStock is NULL then Null

Else

if(NettStock< sum([OutStanding Qty]),NettStock-sum([OutStanding Qty]),NettStock)

PrashantSangle · ‎2015-10-05

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

SreeniJD · ‎2015-10-05

Hi Suveccha

You can ALT function for this..

PrashantSangle · ‎2015-10-05

Hi,

if(isnull(NetStock) or len(trim(NetStock))=0,'Null',YourExpression)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

PrashantSangle · ‎2015-10-05

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

avinashelite · ‎2015-10-05

try like this:

if (len(trim(NettStock))=0 ,null(),

if(NettStock< sum([OutStanding Qty]),NettStock-sum([OutStanding Qty]),NettStock))

sasiparupudi1 · ‎2015-10-05

=if(len( trim(NettStock))=0,'Null',if(NettStock< sum([OutStanding Qty]),NettStock-sum([OutStanding Qty]),NettStock))

jagan · ‎2015-10-05

Hi,

Try like this

=if(Len(Trim(NettStock)) = 0, 'Null',

if(NettStock< sum([OutStanding Qty]),NettStock-sum([OutStanding Qty]),NettStock))

Hope this helps you.

Regards,

Jagan.