topic Re: Help For Sum Function (Set Analyses) in QlikView

Help For Sum Function (Set Analyses)

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

On the filter screen, when 2017 and 2018 is selected, I can see all available months for selection. However, while doing the calculations, I want to use the months of 2018 only. For instance, when I execute this code, the biggest year 2018 can be selected as well as the biggest month the 12th can be selected whereas there is no 12th month available for 2018 in my dataset, due to this it doesn't work properly. What I want is, when I select a year, months should be filtered out based on the selected month and calculations should be done accordingly.

Sum({$<Year={"$(=(Max(Year)))"}, Month={"$(=(Max(Month)))"}>} Envanter)

I tried this but doesnt work

Sum({$<Year={"$(=(Max(Year)))"}> * $<Month={"$(=(Max(Month)))"}>} Envanter)

Re: Help For Sum Function (Set Analyses)

tresB — Mon, 02 Apr 2018 12:32:00 GMT

Ideally, in this scenario you should use date field instead, like:

Sum({$<Year, Month, Date={">=$(=MonthStart(Max(Date))) <=$(=MonthEnd(Max(Date)))"}>} Envanter)

Re: Help For Sum Function (Set Analyses)

sunny_talwar — Mon, 02 Apr 2018 12:32:22 GMT

Try this

Sum({$<Year = {"$(=Max(Year))"}, Month = {"$(=Max({<Year = {'$(=Max(Year))'}>}Month))"}>} Envanter)

Re: Help For Sum Function (Set Analyses)

Anonymous — Mon, 02 Apr 2018 13:59:21 GMT

Thank You so much , its work

Re: Help For Sum Function (Set Analyses)

sunny_talwar — Mon, 02 Apr 2018 14:00:55 GMT

Great, we are glad that we were able to help