Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Master II
Master II

Split the total bar in the stacked chart

I have a stacked chart with two dimensions. I am able to show the stacked chart but having trouble to split the 'Total" bar. Please see the sample attached qlikview file and the screen shot:

I want the "Total" bar to split into 3000 (Which is the total for Dim2=1) and 2300 (Which is the total for Dim2=2).

Thank you for your time.

Split-Total_Bar_ScreenShot1.jpg

1 Solution

Accepted Solutions
Highlighted

Re: Split the total bar in the stacked chart

May be this?

Capture.JPG

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)

View solution in original post

7 Replies
Highlighted

Re: Split the total bar in the stacked chart

May be this?

Capture.JPG

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)

View solution in original post

Highlighted
Master II
Master II

Re: Split the total bar in the stacked chart

Anil,

Is it possible to do on the front end with out the island table ?

Highlighted

Re: Split the total bar in the stacked chart

I really hate to do in UI, It kills the performance. I believe we can club using this.

Pick(Match($Field, Dim1), 'Dim1' , 'TOTAL')


Note - Without hesitate i will say, This will show "out of object" if filter happens and search to all fields and pick only Dim1 to clun TOTAL. That may not a good practice.

Q) Why you didn't like Island Table?

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)
Highlighted
Master II
Master II

Re: Split the total bar in the stacked chart

Agree, Island table is the best but I should not touch the script.

Highlighted

Re: Split the total bar in the stacked chart

Good, Still we can force it.. I got same from customer but i request them to go with Island one only. Let me invite tresesco whether he has some inputs to understand better..

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)
Highlighted
MVP
MVP

Re: Split the total bar in the stacked chart

Alternatively you can use synthetic dimension (using valuelist()/valueloop()). However, that would not be responsive to your selection. Hence the better is what Anil has already suggested.

Thanks Anil for the invite.

Highlighted

Re: Split the total bar in the stacked chart

If you have time, Please made in QVW using ValueList and ValueLoop. I even wonder how this goes..

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)