set analysis syntax

[Tmassimo]

Hi,

I use this set analysis to filter the data that belong to a week:

sum({$< tt_settimana ={"$(=vSettimana)"}>} tt_hh_inserite)

vSettimana is a variable so defined:

LET vSettimana = year(today()) & '-' & week(today()-7)

And is works correctly.

Now I need to filter the data >= vSettimana. I try some different syntax:

sum({$< tt_settimana ={"$(>=vSettimana)"}>} tt_hh_inserite)

sum({$< tt_settimana ={">=$(=vSettimana)"}>} tt_hh_inserite)

but these don't give me any result.

Can anyone help me, please?

[lironbaram]

hi 

this one should work 

sum({$< tt_settimana ={">=$(=$(vSettimana))"}>} tt_hh_inserite)

[PrashantSangle]

Some of the possible reason for not working is
1: result which you are getting for variable is in string. not in number because of '-' in it and you can not give range for text. so in that case convert it into number by removing '-' from both.

Regards,

[lfetensini]

The expression cant be walk in up or down because its a "text" with '-' and not a number to be >=. Think about letter D, can E be >=D? Absolutely not.

Change your variable:

OLD (2019-30):
LET vSettimana = year(today()) & '-' & week(today()-7)

NEW (201930):
LET vSettimana = Year(Today()) & Week(Today()-7)

In Set, use:

Sum({<tt_settimana={">=$(=vSettimana)"}>} tt_hh_inserite)

You can ADD a Field in your calendar to walk (Week + 1) ou (Week - 1) between years if necessary. Try it:

AutoNumber(Num(Year(DATAFIELD)*54) + Num(Week(DATAFIELD))) as WeekID

Then use WeekID to do >= or <= and etc.

[Tmassimo · Accepted solution]

Thank you,

I removed '-'  and now the set analysis works correctly.

[lfetensini]

"Like" it the answers that are helpful to you and flag as solved the one that helped you solve.

Cheers.