Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
merry2018
Creator III
Creator III

Value from Part A, show at Part B

Hello Together,

I need yout help again for a Problem.

I will aggregar the Value from Part A on the topic from Part B, show like this:

Parts Value Shifted Total
A 15 0 15
B 23 15 38

 

I tried to do it like that at Shifted:

 

if(Part=B,
   sum({<Part={'A'}>}Value),
   0
  )

 

 

  At Total I like to take some how that:

 

if(Part=B,
   sum({<Part={'A'}>}Value) + sum(Value),
   sum(Value)
  )

 

 

How can it work, that I see the right Shift and Sum and not 0 at B.

 

Regards
Merry 

Labels (2)
6 Replies
hic
Employee
Employee

Use the following in a table:

Dimension: Parts
Measure1: Sum(Value) - Label it 'Value'
Measure2: Above(Sum(Value)) - Label it 'Shifted'
Measure3: RangeSum(Sum(Value),Above(Sum(Value))) - Label it 'Total'

Sort by Dimension.

Now, the question is what you want for Part C? If you want a full accumulation, you can do a

RangeSum(Sum(Value),Above(Accumulation)) - Label it 'Accumulation'

merry2018
Creator III
Creator III
Author

hat I thougth as well, but that not working, because I have 3 Parts and 2 of them sould geht the Value from the 3th one.

A get the Value A + C
B get the Value B + C
C get the Value  C
hic
Employee
Employee

You need to clarify the logic. What you write in the last comment is not the same as the original question.

merry2018
Creator III
Creator III
Author

There is not realy a logic, because there are 3 different Parts and one will get only the own Value and the other two sould get there own Value and that vrom the first one (in the Example above it is from Part C).

Is the logic importen, if there not more then they 3 it is just that Variant, how I discribe.

Shepherd69
Contributor III
Contributor III


@merry2018 wrote: JCPenneyKiosk

Hello Together,

I need yout help again for a Problem.

I will aggregar the Value from Part A on the topic from Part B, show like this:

Parts Value Shifted Total
A 15 0 15
B 23 15 38

 

I tried to do it like that at Shifted:

At Total I like to take some how that:

How can it work, that I see the right Shift and Sum and not 0 at B.

 

Regards
Merry 


there are 3 different Parts and one will get only the own Value and the other two sould get there own Value and that vrom the first one

Butterfield
Contributor III
Contributor III

Thanks for the information, I will try to figure it out for more. Keep sharing such informative post keep suggesting such post.

 

LiveTheOrangeLife.com