Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to create a table that looks like this where the blue, red, and gray bars are predefined values. The orange, yellow, and green bars are also pre-defined values (left) but I also need a duplicate bar next to them that change based on user entries (right). I need the three middle bars to group under one label. I am thinking this may be accomplished with multiple dimensions but I'm not quite sure how to set it up. Any suggestions would be appreciated! I don't want to group the expressions because I need them all visible at the same time.
It looks like the classic Groupped Par Chart:
cheers,
Oleg Troyansky
QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense
It looks like the classic Groupped Par Chart:
cheers,
Oleg Troyansky
QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense
To me it looks like Tetris
Oleg,
I get that but I'm not sure how to load the two dimensions. right now I'm getting the equivalent of 6 side by side waterfalls squished into the table. Do I just need one expression that says IF left (left bar) then this value, else that value (for right bar)?
Yes, exactly - that's how it should work.
Ok thank you. I'll work on that.
Excellent! Please mark the answers as helpful/correct and close the thread 🙂
I will be happy to as soon as I get it correct
One more question... how do I eliminate the gap between the bars that only use one of the dimensions? I tried suppressing when value is null but it's not responding to that. Also, it won't show grid lines even though I have it set to show them. thoughts on that?
I have managed to get the chart as I want it. Thank you Oleg for your help!!