topic Re: Sum of Sales for Null Id in QlikView

Sum of Sales for Null Id

Thu, 07 Aug 2014 05:46:19 GMT

Hello everyone,

I have a table with ProductId and respective sales.Requirement is to sum(Sales) where productId is null.I have write following condition but it didnt work please if anyone has any idea please share with me.

Syntax

Sum({<ProductId={-}>}Sales)

I know,I have missed something but I didnt get what it is.

Table is in following snapshot

Re: Sum of Sales for Null Id

CELAMBARASAN — Thu, 07 Aug 2014 05:50:36 GMT

Try

Sum({<ProductId-={'*'}>}Sales)

Sum({<ProductId={"=IsNull(ProductId)"}>}Sales)

Thanks

Re: Sum of Sales for Null Id

amit_saini — Thu, 07 Aug 2014 05:52:43 GMT

Bhawna,

Try this:

sum( if(isnull(ProductId), Sales))

Thanks,

Re: Sum of Sales for Null Id

PradeepReddy — Thu, 07 Aug 2014 05:56:24 GMT

Method-1

In Script

NULLASVALUE ProductID,Sales...

Set NullValue = 'PN' ;

Load ProductID,Sales from Sales_Tab;

In Expression: Sum({<ProductID={'PN'}>}Sales)

Method-2

sum( if(isnull(ProductId), Sales))