topic Re: Set Analysis with Date Variables in QlikView

Set Analysis with Date Variables

Carpy — Sat, 16 Nov 2024 18:52:58 GMT

Hi new here so apologies if others have answered this one -

sum(
{<YearMonth,YearMonth={'>= $(vYearMonth2PrevToData) <= $(vYearMonthToData) '}>}
Amount)

The variable names aren't great but they are to drive the date back to when the data corresponds and they seem to be working fine in terms of matching the right date - however this sum results in 0 despite everything showing correct

OK - SUM({YearMonth,YearMonth={'>=20151 <=20153'}>}Amount)

If I just use one or the other variable it provides the answer so it has to have something to do with me trying to define the range to do the sum over.

Any help appreciated - even the learning I am doing suggests I have everything correct

Re: Set Analysis with Date Variables

sunny_talwar — Thu, 26 Mar 2020 12:15:08 GMT

Can you try this

Sum({<YearMonth = {"$(='>=' & vYearMonth2PrevToData & '<=' & vYearMonthToData)"}>} Amount)

Sum({<YearMonth = {"$(='>=' & $(vYearMonth2PrevToData) & '<=' & $(vYearMonthToData))"}>} Amount)

Re: Set Analysis with Date Variables

Carpy — Thu, 26 Mar 2020 13:19:32 GMT

Thank you so much Sunny for the quick reply - both seem to be working fine.

Any reason why I had to define them as strings or in-case I have used the wrong terminology '>='

Re: Set Analysis with Date Variables

sunny_talwar — Thu, 26 Mar 2020 13:58:46 GMT

You can try this also

Sum({<YearMonth = {">=$(=vYearMonth2PrevToData)<=$(=vYearMonthToData)"}>} Amount)

Sum({<YearMonth = {">=$(=$(vYearMonth2PrevToData))<=$(=$(vYearMonthToData))"}>} Amount)