topic Set analysis in QlikView

Set analysis

Thu, 09 Oct 2014 19:14:49 GMT

I am trying to calculate the set based on the month and sum the accounts.

Sum{<Month = {"=>$(Month(today()))<=$(MaxString(Month)) "}>} accounts .The value should be pretty much from the present month and to end of the year.

But the set analysis is not working properly. Please advise.

maxgro — Thu, 09 Oct 2014 19:26:19 GMT

sum({$<Month ={">=$(=max(Month(Today())))<=$(=max(Month))"}>} account)

sum({$<Month ={">=$(=max(Month(Today())))<=12"}>} account)

Vegar — Thu, 09 Oct 2014 19:26:47 GMT

Set with month() can be tricky. Month is a dual value and can be string and number. Make sure that you don't compare a digit with a string.

-Vegar