topic Re: Need Help For Sum Function in QlikView

Need Help For Sum Function

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

Hi everyone,

When multiple selections are made on the data model,I just want to process the biggest one. The code structure looks like this:

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

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

For example, when I choose 2015-2016-2017-2018, I want sum of data for 2018. This code is included all the years.

Please help me.

sunny_talwar — Thu, 22 Feb 2018 17:19:32 GMT

May be try this (Remove the equal sign before the dollar sign expansion for Year's modifier

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

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

shiveshsingh — Thu, 22 Feb 2018 17:26:31 GMT

Hi Sunny

I think '=' sign before $ is not the correct way while using set analysis?

Sum({$<Year={"=$(=(Max(Year)))"}

sunny_talwar — Thu, 22 Feb 2018 17:28:16 GMT

I believe so... that is why I recommended to remove it.

shiveshsingh — Thu, 22 Feb 2018 17:29:18 GMT

Thanks

sunny_talwar — Thu, 22 Feb 2018 17:29:45 GMT

Hahahaha no problem

Anonymous — Fri, 23 Feb 2018 08:05:02 GMT

Thank you so much guys

İt works

shiveshsingh — Fri, 23 Feb 2018 08:30:20 GMT

Please close the thread