topic Re: Calculate expression if a field in the database is null in QlikView

Calculate expression if a field in the database is null

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I am loading a table from a database.

I have 3 fields, product, sales and sales estimated.

i would like an expression of the sales estimated that on a row if sales is null then sum sales estimated if is not null then don´t do anything.

thank you

kaushiknsolanki — Wed, 08 Feb 2017 17:53:23 GMT

Hi,

You can create a flag in script like below.

Load Product,Sales,SalesEstimated,If(Isnull(Sales),1,0) as NullFlag From xyz;

Now in chart expression you can write.

Sum({<NullFlag = {"0"}>}SalesEstimated)

So this expression will consider only records which have value.

Regards,

Kaushik Solanki

jayanttibhe — Wed, 08 Feb 2017 19:02:58 GMT

OR even dont need set analysis expression :

Simply Do : Sum(NullFlag*SalesEstimated)

Wed, 08 Feb 2017 19:04:56 GMT

Hey,

You can handle it in script and do not worry in expression:

Load
Product,
Sales,
IF(ISNULL(Sales),[sales estimated], 0) as [sales estimated]
;

This will maintain value for sales estimated, only when Sales is null

BR,

Kuba