topic Re: Chart with multiple expressions in QlikView

Chart with multiple expressions

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

Please see the attached screenshot.

I have two expressions - one for forecast and one for ytd actual.

How would display these two expressions separately - meaning I want two bars on the chart instead of being "stacked"? Is this possible? I've already looked through pretty much all of the chart properties/settings and didn't see anything which would allow me

to do this.

Thank you

Re: Chart with multiple expressions

stigchel — Thu, 25 Oct 2018 14:00:32 GMT

It is in the Style tab of the chart properties

Re: Chart with multiple expressions

raman_rastogi — Thu, 25 Oct 2018 14:00:38 GMT

change stacked to Grouped

Property -> Style->Grouped

Regards

Raman

Re: Chart with multiple expressions

Anonymous — Thu, 25 Oct 2018 14:08:03 GMT

Yes, I did try to switch from "Stacked" to "Grouped" and I didn't see the effect. After playing around with a bit more, it turned out I had too many dimensions. Looks like if I had more than one dimension, it would always be "Stacked". So I reduced my dimension to one, it now displays two bars.

Thank you for your replies.

Re: Chart with multiple expressions

Anonymous — Thu, 25 Oct 2018 14:24:50 GMT

So can you have "Grouped" with say with two dimensions? For example, can I show FiscalYear and FiscalQuater (as dimensions) and expressions being YTD vs. Actual in my screenshot and yet with two separate bars? If this possible? As I said, it seems to only work with one dimension.

Re: Chart with multiple expressions

vinod22kv — Fri, 26 Oct 2018 14:42:52 GMT

Hi,

in bar chat it is not posible . hope it is posible in line chat or combo chat. did you try that. ?

Rergards,

Vinod.

Re: Chart with multiple expressions

Anonymous — Fri, 26 Oct 2018 14:45:17 GMT

No I did not try line or combo.

I left it as-is for now which with one dimension on bar chart.