How to calculate in Expressions/Dimensions and add % Row?

[#1]

Hi,

i have a big problem with calculating Expressions/Dimensions in Pivot Tables (Qlikview 10).
I want to get the following result:

Here you find my example QVW File:
[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/4666.Question.zip:550:0]

I cant insert *.qvw Files directly, so please take this *.zip File.

I tried three different ways to get the result above, but did not found a solution. Thats frustrating [:'(]
Perhaps one of you have an idea for me?

Many thanks!

[lironbaram]

hei

attach is an example of what you asked for

but i must say it was better if you could connect your table

that way the formulas will be much simpler

[gandalfgray]

I was looking at your problem but I get a bit confused over your definition of "Gesamt" (=Total, right?)

For instance, looking at the underlying data "Daten" table there are 9 records for April, but you get 15 as "Gesamt"?

Should not each of the Daten-records belong to one and only one of Kontakte/Nicht existent/Nicht realisiert ?

[#4]

Hey RoiUser,

thanks for your really fast answer.
You are right, the formula really looks complicated to build (especially automatical)
In the real application i would get the formulas from a sql server.
Other questions:

1. Is there a possibility to get the minus sign out of the table?
2. Can i solve the problem using set analysis in expressions?
3. What do you mean when you say "...it was better if you could connect your table.."?
4. How do you inserted *.qvw File? When i wants to insert i i got an error... (i used insert media)

Regards, Martin

[lironbaram]

hey

1. yes ,in the chart poreprties go to presention tab, check the box allways fully expended.

3 . if the rows are item kind maybe you can join them to the fact table , all the caculation then will be faster.

4. in the top of the screen go to the tab option there you have file attachment

[#6]

@ Göran:

You are right, the data is only an example to show you my problem.

[#7]

@ RoiUser: Another big problem with your solution is, that i can't change the width of the first row without changing the width of the other rows automatically.

[lironbaram]

it is not problem with thesolution

in qlikview all the rows have the same width

you can change only column width