topic Re: HELP WITH TOTAL VALUE in QlikView

HELP WITH TOTAL VALUE

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

Hi,

could anyone please help me on how I can have the total value here per month?

vishsaggi — Mon, 29 Aug 2016 22:07:05 GMT

What is the TotalValue you are expecting here ?

Something like this ?

Change the expression to this and see if this is what you are looking for :

= Pick(Match(left([Unique Resource ID],1), 1 ,2, 3, 4, 5, 6, 7, 8, 9), Sum([Distribution Value])/ Sum(Total [Resources Quantity]) )

sunny_talwar — Mon, 29 Aug 2016 22:12:49 GMT

Like this?

Expression:

Sum(Aggr(If(left([Unique Resource ID],1)=1

or left([Unique Resource ID],1)=2

or left([Unique Resource ID],1)=3

or left([Unique Resource ID],1)=4

or left([Unique Resource ID],1)=5

or left([Unique Resource ID],1)=6

or left([Unique Resource ID],1)=7

or left([Unique Resource ID],1)=8

or left([Unique Resource ID],1)=9

,Sum([Distribution Value])/([Resources Quantity])), [Unique Resource ID], [Reference Month]))

or this:

Sum(Aggr(If(Match(Left([Unique Resource ID], 1), 1, 2, 3, 4, 5, 6, 7, 8, 9),

Sum([Distribution Value])/([Resources Quantity])), [Unique Resource ID], [Reference Month]))

silvia_assuncao — Wed, 31 Aug 2016 18:21:56 GMT

great guys!

it worked!

thanks