Stack barchart

[Anonymous]

Hi Qlik Experts,

I have to create a stack bar chart , where all 4 stacks should  cover 100% display but do not show value as % in data points.

They should show actual numbers for particular selection as shown in example below.

For eg- if for Jan, LMN has "Actual 1"=123 , "Actual 2"=22,"Actual 3"=11, then it should show as image 2.

I tried creating it by using normal stackbar chart & showing datapoint as number or % but its not solving the purpose.

Because when I try showing actuals as data points , the stack doesn't cover 100% display.

Image created in excel.

Appreciate the help,

Thanks in adv.

[Anil_Babu_Samineni]

Try to build same in Qlikview and explain where it is not working. I may understand your intend but more clear may help us

[pradosh_thakur]

like this

[Anonymous]

In qlikview 100%  stackbar graph is correct but it gives me below data points-

But actually I want 100% range stackbar chart to show  data points as original actual value as in we get in normal stack chart as below-

[woshua5550]

Dual() function will help you out

check this

[mdmukramali]

Hi,

may be like this,

Find the attached Application (Updated File)

Thanks,

Mukram.

[Anonymous]

Thank You !

[Anonymous]

Hi Dave, the formula isn't working in my case , its giving me abrupt result on data points. (though creating 100% range stackchart)

Like A1,A2 mentioned in your doc are fields

in my case, field is date and stacks are generated using variables in expression.

I tried replacing A1,A2 with expressions , its giving me abrupt result on data points. (though creating 100% range stackchart)

[mdmukramali]

Hi,

Have you checked my Solution?

[woshua5550]

can you provide a screenshot of your problem ? or provide a sample app

I'm not sure what does "abrupt result on data points" means , data label not looks good ? if yes ,you can use Num() function to format the data