Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
silvia_assuncao
Creator
Creator

HELP WITH TOTAL VALUE

Hi,

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

1 Solution

Accepted Solutions
sunny_talwar

Like this?

Capture.PNG

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]))

View solution in original post

3 Replies
vishsaggi
Champion III
Champion III

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

Like this?

Capture.PNG

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
Creator
Creator
Author

great guys!

it worked!

thanks