Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Discussion Board for collaboration related to QlikView App Development.

Announcements

QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: **REGISTER NOW!**

- Qlik Community
- :
- All Forums
- :
- QlikView App Dev
- :
- Re: Value from Part A, show at Part B

Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

merry2018

Creator III

2022-03-04
03:34 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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

348 Views

6 Replies

hic

Employee

2022-03-04
06:55 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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'

312 Views

merry2018

Creator III

2022-03-04
07:02 AM

Author

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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 |

309 Views

hic

Employee

2022-03-04
07:39 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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

300 Views

merry2018

Creator III

2022-03-07
03:28 AM

Author

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.

276 Views

Shepherd69

Contributor III

2022-03-07
07:19 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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

269 Views

Butterfield

Contributor III

2022-03-08
06:22 AM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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