topic Accumulate Value on Text Box (Balance Value ) in QlikView

Accumulate Value on Text Box (Balance Value )

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

How to get all the accumulate value on and before the selected month ( As Balance Value )

on other word

all accumulate value for all period up to selected month

Plz Look to my Attachment

Re: Accumulate Value on Text Box (Balance Value )

ghassanaldalati — Mon, 28 Nov 2016 08:48:52 GMT

when I select { month ( May ) - Year ( 2015) } I get all the Accumulate amount from Day 1 up to May2015 (Full ccumulate amount for all years before + 5 months on May2015)

I need the formula on TextBox

Re: Accumulate Value on Text Box (Balance Value )

MK_QSL — Mon, 28 Nov 2016 08:56:11 GMT

Something like below..

SUM({<YourDateField = {"$(=Date(MakeDate(Max(Year),Max(Month))))"}>}Sales)

Change your field names according to your application.

Re: Accumulate Value on Text Box (Balance Value )

tresB — Mon, 28 Nov 2016 08:56:37 GMT

Try something like:

Sum({<Year,Month, Date={'<=$(=Date(Max(Date)))'}>} Value)

Re: Accumulate Value on Text Box (Balance Value )

ghassanaldalati — Mon, 28 Nov 2016 09:51:29 GMT

Plz have a look to my attachment .. and help

Re: Accumulate Value on Text Box (Balance Value )

ghassanaldalati — Mon, 28 Nov 2016 09:51:39 GMT

Plz have a look to my attachment .. and help

Re: Accumulate Value on Text Box (Balance Value )

tresB — Mon, 28 Nov 2016 09:54:52 GMT

The working expression is: =Sum({<Year,Month, Date={'<=$(=Date(Max(Date)))'}>} Sales)

Re: Accumulate Value on Text Box (Balance Value )

MK_QSL — Mon, 28 Nov 2016 09:56:59 GMT

Use this..

=SUM({<Month, Year, Date = {'<=$(=Date(Max(Date)))'}>}Sales)