topic Re: Pivot table with additional formula's in values in QlikView

Pivot table with additional formula's in values

Thu, 20 Aug 2015 20:28:05 GMT

I am still very new to qlikview. I have created a pivot table (it shows sales forecast information) that successfully shows the values based on two dimensions. The first dimension (vertically) shows the sale probability, and the second (horizontally) shows the rolled up values per selected month. See attached screenshot 1.

I now want to duplicate this pivot table to show a factored value for certain probabilities. For instance the 50% values should be devided by 2 and the 80% values should be divided by 3. I then want to calculate the value of the three highest probabilities (50, 80 and 100). See screenshot 2 from excel with illustrated example. Is this at all possible?

Re: Pivot table with additional formula's in values

ecolomer — Fri, 21 Aug 2015 03:50:40 GMT

You can upload an example with data to help you?

A solution can be have a variable with values 2,3, ... probabilities (20,50,80)

Re: Pivot table with additional formula's in values

Fri, 21 Aug 2015 06:52:24 GMT

Sure thanks I made a sample file with dummy data.

I have the two tables saved next to each other. The one on the right is the one where I would need the formula's as per the screenshot from excel in the first post.

Thank you very much for your help.

Re: Pivot table with additional formula's in values

ecolomer — Fri, 21 Aug 2015 09:14:56 GMT

is this you need?

Re: Pivot table with additional formula's in values

Fri, 21 Aug 2015 10:15:44 GMT

I've learnt something new! Thank you.

The probability section is working exactly as I wanted it to. Thank you.

Is there any way we can show the correct factored total?

Re: Pivot table with additional formula's in values

ecolomer — Fri, 21 Aug 2015 12:11:56 GMT

I can see your image file.

If my response is correct for you, mark it and close the post.

Tank's