topic Re: dynamic total in QlikView

dynamic total

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

Hi community,

How to calculate dynamically total sales which is not based on maxdate which should be based on seletion

If select any month of the corresponding year then total sales should display

Sum({<Date = {'>=$(=monthstart(max(Date),-2))<=$(=max(Date))'}>}sales)

It returns only based on maxdate.

Any Ideas??

Thu, 02 Jun 2016 12:28:20 GMT

Hi,

try this

Sum({$<Date = {'>=$(=monthstart(max(Date),-2))<=$(=max(Date))'}>}Amount)

-Joyson G

sunny_talwar — Thu, 02 Jun 2016 12:28:51 GMT

Not sure I completely understand. You want to see last three months and total as the current month?

satishqlik — Thu, 02 Jun 2016 12:30:48 GMT

Yes Sunny!!

But which is not based on maxdate it should be based on selection.

Is it possible to achieve?

Pls help

Anonymous — Thu, 02 Jun 2016 12:31:42 GMT

Hi try this,

Sum({<Date = {'>=$(=monthstart(max(Date),-2))<=$(=Month(Date))'}>}Amount) from last 3 months

sunny_talwar — Thu, 02 Jun 2016 12:32:22 GMT

May be like this:

If(Dimensionality() = 0, Sum(Amount), Sum({<Date = {'>=$(=monthstart(max(Date),-2))<=$(=max(Date))'}>}Amount))