Axis value problem

[#1]

Hi all,

I have been sent the below Excel chart to re-create in QlikView.

Is this really possible? The axis is showing a % but the values of the bars are integer amounts.

Do you have any ideas of a) how to re-create this chart or b) any good ideas on how to represent this data?

The requirements are that the sum of the two stacked values add up to 100% so for example 14+5=100%

Thanks

Asa

[prma7799]

Share some sample app

[#3]

Sorry, the data is classified so I'm not allowed to unfortunately...

[prma7799]

Send scramble data ..

Scrambling Data

[vinieme12]

no one needs to see actual data, just a sample data set that best represents the data you are working with

Anyway here is an example

Dummy Data

LOAD * inline [

Cat1,SubCat,TOTALVAL

1,x,10

1,y,20

2,x,85

2,y,65

3,x,74

3,y,100

];

Barchart Set to Stacked Style

Dimensions

Cat1

SubCat

Expression

dual( sum(TOTALVAL),

Sum(TOTALVAL)/sum(total <Cat1> TOTALVAL)

)

[vinieme12]

Sample app

[#7]

Thank you for this!

In my example it looks like this:

The stacked values are made up of two expressions, Live and Outstanding

One dimension which is Area

The 100% should be the total of Live and Outstanding.

Asa

[vinieme12]

Thats simple,

Remove Subcat dimension and add two expressions instead

check attached, the trick here is to use Dual()

If this is still confusing, please post your sample app that best represents your scenario,

if your query is resolved please close the thread by marking a response as correct