Discussion board where members can get started with QlikView.
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.
May be this?
May be this?
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?
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..
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.
If you have time, Please made in QVW using ValueList and ValueLoop. I even wonder how this goes..