topic Re: Expression logic in QlikView

Expression logic

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

HI All,

How can i right the expression when i need to show sum of sale when LogedDate is null and Recieved Date is null.

thanks

shiveshsingh — Thu, 22 Mar 2018 10:45:15 GMT

Try this

if(isnull(LogedDate ) and isnull([Recieved Date]),Sum(Sales))

MK_QSL — Thu, 22 Mar 2018 10:50:35 GMT

You can create back end flags for null dates.

If(IsNull(LoggedDate) or Len(Trim(LoggedDate))=0, 1) as Flag_LoggedDate,

If(IsNull(ReceivedDate) or Len(Trim(ReceivedDate))=0, 1) as Flag_ReceivedDate

now use

=SUM({<Flag_LoggedDate = {1}, Flag_ReceivedDate = {1}>}Sales)

Or without creating flags...

=SUM(IF(IsNull(LoggedDate) and IsNull(ReceivedDate),Sales))

MK_QSL — Thu, 22 Mar 2018 10:56:55 GMT

=SUM(Sales)-SUM({<LoggedDate = {"*"}>+<ReceivedDate = {"*"}>}Sales)

=SUM({1}Sales)-SUM({1<LoggedDate = {"*"}>+1<ReceivedDate = {"*"}>}Sales)