topic Re: Bar chart - formatting question in QlikView

Bar chart - formatting question

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

Hi,

I am looking at a Bar Chart that was created by another developer. Here's a screenshot.

I pretty much have compared every setting between my version and the one created by someone else and I don't see any

difference. But I can't multiple years to group together like they had it. In the above, when the app is first loaded without making any selection, the bar chart shows the last highest 3 years for Jul, Aug, Sept and etc.. The expression is coded as max(year), max(year)-1

and max(year)-2. When I do the same on my version, it only shows one year at a time. For example: 2016 Jul, 2016 Aug and etc. Then when I make a selection on Year 2015, it will show 2015 Jul, 2015 Aug and etc.

What am I missing or how do you make it so it will look like the above?

Thank you

Re: Bar chart - formatting question

Anonymous — Mon, 05 Dec 2016 15:18:50 GMT

Meant to say "But I can't get multiple years to group together like they had it"

Re: Bar chart - formatting question

sunny_talwar — Mon, 05 Dec 2016 15:25:05 GMT

Would you be able to share a sample?

Re: Bar chart - formatting question

Anonymous — Mon, 05 Dec 2016 15:33:59 GMT

Sunny,

Unfortunately I won't be able to as it contains company data. Would you be able to create a quick prototype to mirror the above and perhaps walk me through the key properties or configuration??

Re: Bar chart - formatting question

sunny_talwar — Mon, 05 Dec 2016 15:34:52 GMT

I wish I had time to do that... but I hope someone else might be able to help you out here

Re: Bar chart - formatting question

Anonymous — Mon, 05 Dec 2016 15:36:16 GMT

Also I tried to copy this bar chart over to my QVW file. However it is not copying. I did a "copy to clipboard - object" and on my qvw, I did a "past sheet object" but I don't see it. Is there a trick to this?

Re: Bar chart - formatting question

sunny_talwar — Mon, 05 Dec 2016 15:39:58 GMT

There may be a show/hide condition for this chart. Look for a hidden chart through sheet properties and the disable any show/hide conditions on the layout tab

Re: Bar chart - formatting question

sunny_talwar — Mon, 05 Dec 2016 15:40:18 GMT

or you can just disable any show/hide condition before you copy and paste this chart

Re: Bar chart - formatting question

Anonymous — Mon, 05 Dec 2016 15:40:26 GMT

this might be because the copy is not allowed

Re: Bar chart - formatting question

Anonymous — Mon, 05 Dec 2016 15:48:46 GMT

You are correct. There was a condition in the Layout. I changed it to "Always" and was able to copy it. Then I replaced the original expressions with mine and the chart still shows one year at a time. So it does not appear to be

chart settings. I can't image is the expression either. Can it?? My expressions are slightly different in terms of the criteria within the SUM( {1 <>} Total) and the differences are within the <> which is really the WHERE clause in SQL.

Re: Bar chart - formatting question

Anonymous — Mon, 05 Dec 2016 16:08:20 GMT

what is the difference in set Analysis?

can you post the Expression of both Versions (that one which works and your part?)

Re: Bar chart - formatting question

Anonymous — Mon, 05 Dec 2016 16:19:20 GMT

Finally figured out !!

This expression doesn't work

= -1 * SUM( {

FiscalYear={$(=max(FiscalYear)), $(=max(FiscalYear)-1)},

Location={'EAST'}

}

Total

)

However this works. It seems the bar chart needs 3 sets of years. Can you guys confirm this with me?

Everyday is a learning day for me.

= -1 * SUM( {

FiscalYear={$(=max(FiscalYear)), $(=max(FiscalYear)-1), $(=max(FiscalYear)-2)},

Location={'EAST'}

}

Total

)

Re: Bar chart - formatting question

Anonymous — Mon, 05 Dec 2016 16:26:29 GMT

great that you found it

With Qlikview you always learn something new, even if you have years of experience

Re: Bar chart - formatting question

Anonymous — Mon, 05 Dec 2016 16:28:41 GMT

But am I correct the Bar Chart needs a minimum of 3 sets of fiscal year of data in order to display the data as shown in my original screenshot?

Re: Bar chart - formatting question

Anonymous — Tue, 06 Dec 2016 10:28:48 GMT

that's correct. otherwise there are missing years

you force Qlikview to get data from those years you specify in set analysis