Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Stack barchart

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.

1 Solution

Accepted Solutions
woshua5550
Creator III
Creator III

you can do it in two ways

1.one dimension and four expressions

2.two dimensions and one expressions

PFA

plz make sure that these two checkboxes are checked

1.png

2.png@

View solution in original post

16 Replies
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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
pradosh_thakur
Master II
Master II

like this

Capture.PNG

Learning never stops.
Anonymous
Not applicable
Author

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
Creator III
Creator III

Dual() function will help you out

微信截图_20171114183045.png

check this

mdmukramali
Specialist III
Specialist III

Hi,

may be like this,

281564.PNG

Find the attached Application (Updated File)

Thanks,

Mukram.

Anonymous
Not applicable
Author

Thank You !

Anonymous
Not applicable
Author

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
Specialist III
Specialist III

Hi,

Have you checked my Solution?

woshua5550
Creator III
Creator III

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