topic Issue with date in set expression in QlikView

Issue with date in set expression

Thu, 10 Sep 2015 17:35:23 GMT

Hi,

Can someone please help me with below set expression.

I'm having trouble with [Expected Funding Date], I want it to be today() -1:

sum({< [Transaction TFS Status Desc] = {'Funded','Lost','Rejected'},
[Expected Funding Date] = {'< =$( today()-1)'},
[Transaction Status Date Num] = {'>=$(v12MonthsAgoStart)'}
>}USD)

Re: Issue with date in set expression

Clever_Anjos — Thu, 10 Sep 2015 17:37:05 GMT

You should format the output of today()

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

Re: Issue with date in set expression

Thu, 10 Sep 2015 17:39:46 GMT

Thanks Anjos.. Appreciate your help.

Re: Issue with date in set expression

sunny_talwar — Thu, 10 Sep 2015 17:40:07 GMT

Try this may be:

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

[Expected Funding Date] = {"$(='<=' & Date(Today()-1, 'MM/DD/YYYY'))"},

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