topic Re: Previous date by using variable in set expression in App Development

Previous date by using variable in set expression

Zarnabkhan — Tue, 16 Jun 2020 07:54:11 GMT

Hi All,

I'm trying to fetching previous date data in measure by using set expression . My date in number format .

Code :

sum( {$<NUM_DATE=${('v_pre_date')}>} KNIT_BACKLOG_OPENGT )

//Date in number format

//variable value = today(date(NUM_DATE)) - 1

But my code is not working . Please help me .

Re: Previous date by using variable in set expression

raji6763 — Tue, 16 Jun 2020 08:15:39 GMT

hi @Zarnabkhan ,

You can calculate the previous date using these ways

set analysis:

Sum({$<NUM_DATE={'$(Max(NUM_DATE)-1)'}>}KNIT_BACKLOG_OPENGT)

(or)

2.Use variable

a. Create variable : vPreviousDate = Max(NUM_DATE)-1

b. Use set analysis : =Sum({$<[NUM_DATE]= {"$(=vPreviousDate)"}>} KNIT_BACKLOG_OPENGT)

regards,

raji

Re: Previous date by using variable in set expression

Zarnabkhan — Tue, 16 Jun 2020 09:54:41 GMT

Thanks Raji , i tried , but your solution is not working . With fix date working fine.

=sum( {$<[DATE.autoCalendar.Date]={"6/14/2020"}>} KNIT_BACKLOG_OPENGT )

above line with date format working fine but date in number format and using variable is not working .

=Sum({$<[NUMDATE]= {"$(=vPreviousDate)"}>} KNIT_BACKLOG_OPENGT)

above code compiles but gives logical error.

Please Help.

Regards:

Zarnab Khan

Re: Previous date by using variable in set expression

Anil_Babu_Samineni — Tue, 16 Jun 2020 09:59:25 GMT

how did you define the variable? Try this way

=Sum({$<[NUMDATE]= {"=$(=vPreviousDate)"}>} KNIT_BACKLOG_OPENGT)

Re: Previous date by using variable in set expression

tresB — Tue, 16 Jun 2020 10:02:11 GMT

Your variable definition needs to be corrected I guess. Try like:

vPreviousDate = today() - 1

Re: Previous date by using variable in set expression

Zarnabkhan — Tue, 16 Jun 2020 10:19:55 GMT

Thanks to all , your solutions compiles successfully but giving no results.

Re: Previous date by using variable in set expression

raji6763 — Tue, 16 Jun 2020 10:28:12 GMT

could you please check your field name?please share your set expression and variable value

Re: Previous date by using variable in set expression

tresB — Tue, 16 Jun 2020 10:30:17 GMT

Try to share your sample app. Also try like:

vPreviousDate = Date(today() - 1, 'M/D/YYYY')

=Sum({$<[NUMDATE]= {'$(=vPreviousDate)'}>} KNIT_BACKLOG_OPENGT)

Re: Previous date by using variable in set expression

Zarnabkhan — Tue, 16 Jun 2020 10:58:52 GMT

Dear Tresesco thanks for your reply , but your expression giving error please check attached screen shorts .

Re: Previous date by using variable in set expression

tresB — Tue, 16 Jun 2020 11:22:25 GMT

Put '=' sign in variable definition and try.