topic Issue in set expression in QlikView

Issue in set expression

Thu, 10 Sep 2015 20:17:31 GMT

Hi,

Can someone tell me what's wrong with my set expression.

I want sum of USD for all transactions whose funding date is less than today + where expected funding date is null

({< [Transaction TFS Status Desc] -= {'Funded','Lost','Rejected'},

        [Expected Funding Date] = {"<=$(=DATE(today()-1,'MM/DD/YY'))"},

        [Transaction Status Date Num]   = {'>=$(v12MonthsAgoStart)'}


>}USD)

+

sum({< [Transaction TFS Status Desc] -= {'Funded','Lost','Rejected'},

       [Transaction Status Date Num]   = {'>=$(v12MonthsAgoStart)'}


       ,[Expected Funding Flag] = {'N'}

>}USD)

Regards,
Sachin

Re: Issue in set expression

petter — Thu, 10 Sep 2015 20:38:21 GMT

It is very hard to judge just by looking at your expression out of context. Is it possible for you to share a sample QVW-file that illustrates your problem?

Re: Issue in set expression

ramoncova06 — Thu, 10 Sep 2015 20:46:30 GMT

it is like Petter just mentioned is hard to tell what might be wrong since we cannot see what is inside the variables or the date format, the only obvious thing to me is to use rangesum instead of sum(1)+sum(2) because if one of the results of your expressions is null your expression will fail, and by using rangesum the null be considered as a 0

rangesum(

sum(

({< [Transaction TFS Status Desc] -= {'Funded','Lost','Rejected'},

        [Expected Funding Date] = {"<=$(=DATE(today()-1,'MM/DD/YY'))"},

        [Transaction Status Date Num]   = {'>=$(v12MonthsAgoStart)'}


>}USD)

,

sum({< [Transaction TFS Status Desc] -= {'Funded','Lost','Rejected'},

       [Transaction Status Date Num]   = {'>=$(v12MonthsAgoStart)'}


       ,[Expected Funding Flag] = {'N'}

>}USD)

)