topic Re: How to allocate value in other fields in QlikView

How to allocate value in other fields

rassanbekov — Fri, 06 Apr 2018 07:13:15 GMT

Hello!

Please help to create a graph to show in dimension "Group" where Group = "E" "Amount" (expression sum) allocated among other groups which group the code belongs.

I have the following data model:

LOAD * INLINE [

EmplID, Group, Amount, Code

1, A, 100, 123

2, B, 200, 234

3, C, 300, 345

4, A, 400, 456

5, B, 500, 123

6, E, 600, 234

6, E, 700, 123

];

LOAD * INLINE [

Manager, Code, Group

Manager 1, 123, A

Manager 2, 234, B

Manager 3, 456, A

Manager 4, 345, C

];

Re: How to allocate value in other fields

prma7799 — Fri, 06 Apr 2018 07:18:13 GMT

Expected output?

Re: How to allocate value in other fields

rassanbekov — Fri, 06 Apr 2018 07:21:11 GMT

Graph can be a straight table with dimension "Group" and expression "=sum(Amount)". But I need to allocate amount for group "E" among other groups. How can I do??

Re: How to allocate value in other fields

prma7799 — Fri, 06 Apr 2018 07:29:27 GMT

Like this??

Dimension : Group

Expression : Sum({<Group = {'E'}>} Amount)

Re: How to allocate value in other fields

gerry_hdm — Fri, 06 Apr 2018 07:32:41 GMT

How should the values be distributed?
123 of E is in A and B is to be distributed 50 50 or proportionally
234 of E is only available in B

in your INLINE model are synthetic key

Greeting Gerold

Re: How to allocate value in other fields

rassanbekov — Fri, 06 Apr 2018 07:34:47 GMT

No, please carefully read question

Re: How to allocate value in other fields

rassanbekov — Fri, 06 Apr 2018 07:40:13 GMT

The distribution should be 100% for A and 100% for B, but when script read group "E" it should refer to second table and take value from Code -> Group.

To avoid synthetic key, you can rename field "Group" to "Group_2".