topic Re: Axis value problem in QlikView

Axis value problem

Fri, 02 Jun 2017 07:15:26 GMT

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

Re: Axis value problem

prma7799 — Fri, 02 Jun 2017 07:19:20 GMT

Share some sample app

Re: Axis value problem

Fri, 02 Jun 2017 07:23:29 GMT

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

Re: Axis value problem

prma7799 — Fri, 02 Jun 2017 07:26:23 GMT

Send scramble data ..

Scrambling Data

Re: Axis value problem

vinieme12 — Fri, 02 Jun 2017 07:30:02 GMT

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)

)

Re: Axis value problem

vinieme12 — Fri, 02 Jun 2017 07:30:38 GMT

Sample app

Re: Axis value problem

Fri, 02 Jun 2017 10:28:53 GMT

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

Re: Axis value problem

vinieme12 — Tue, 06 Jun 2017 07:53:54 GMT

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