topic Stack Graph in QlikView

Stack Graph

Wed, 02 Mar 2011 16:48:12 GMT

Hello...I need to create a stack graph where the values of my dimension are stacked instead of the expressions. I need a bar for each expression. I have expressions for Hires, Transfers In, Terms, Transfers Out, and Net. My single dimension is a field called Level, which can have values of C14, C15, and C16. Is this even possible?

For example, in the Hire bar, I would have C14, C15 and C16 stacked.

Stack Graph

suniljain — Wed, 02 Mar 2011 17:23:27 GMT

i suggest mini chart for this scenario

Stack Graph

Wed, 02 Mar 2011 17:25:10 GMT

what is a mini chart?

Stack Graph

Wed, 02 Mar 2011 17:36:56 GMT

You need 2 dimensions to get the chart you want to display

1) First one create a calculater dimension = "1"

2) Second : Level

Expression : Sum(Hires)

This works with only one expression

You have another solution to display all your expression but you have to transform your data in the script. I don't know if you have this possibiliy. If so Use CrossTable to create a new field call "Variable" which can take the values Hires, Transfers in....

Your final table must have 3 fields : "Variable" , Level, Value