Choice of dates through variables in set-analysis

[vtatarnikov]

Please advise how to make an expression set-analysis.

Need to set the time (сompare the two periods). I set two variables in objects "slider / calendar": vBeg, vEnd. These variables are obtained by numerical, form 41275. DateSales field type date. I'm trying to write an expression in a straight table:

Sum({<DateSales={">=$(vBeg)<=$(vEnd)"}>}[amount])

Permutation of characters and manipulating types yielded no results. Help me, please.

[lft]

Hi Vlad,

this is a very common issue.

The vBet & vEnd variables should not be numerical

PFA a working example

Loic

[vtatarnikov]

Did exactly the same, but I have not worked

[tresesco · Accepted solution]

Could be because of mismatch in format. Try like:

Sum({<DateSales={">=$(=Date(vBeg))<=$(=Date(vEnd))"}>}[amount])

Otherwise, try to post your sample qvw that demonstrates the issue.

[lft]

Hi Vlad,

If you have found the solution, can you mark this question as answered ?

Thanks a lot,

Loic

[vtatarnikov]

Thanks, works!)