topic Re: Graph design issue in QlikView

Graph design issue

Thu, 11 Feb 2016 11:40:33 GMT

Hello,

I am struggling on a chart and cannot understand where I am going wrong, if it is data setup or graph setup. I have a data set as defined below:

Year	Qtr	Qtrlydate	Instances
2015	2	2015 Qtr 2	0
2015	3	2015 Qtr 3	1
2015	4	2015 Qtr 4	3
2016	1	2016 Qtr 1	6

when I set a bar chart I want to have the sum of the Instances (ie 10) however when I set the properties and the expression for the data is Sum(Instances) for some reason I get 10 but I have 5 bars instead of 1. Any ideas as to why?

thank you.

Roberto

Re: Graph design issue

awhitfield — Thu, 11 Feb 2016 12:32:31 GMT

Hi Roberto,

it would be better if you could upload your qvw, so we can check the chart etc.

Andy

Re: Graph design issue

Mark_Little — Thu, 11 Feb 2016 15:39:57 GMT

Hi,

As Andrew has suggested a sample would be good.

In the mean time,

what dimension(s) are you using?

Screen grab of the chart in question?

Mark

Re: Graph design issue

Anonymous — Thu, 11 Feb 2016 16:00:59 GMT

Please share screenshot of the bar chart to help us figure this better. First question here is to understand what dimension (X axis) do you have in that bar chart? Initial guess here is that perhaps the bar chart is ignoring dimension and is summing up all (hoping there is no set analysis expression to ignore dimension)

Re: Graph design issue

nagarjuna_kotha — Thu, 11 Feb 2016 16:24:59 GMT

Hi ,

For quick solutions , share sample file.

Before check this ....

Re: Graph design issue

Thu, 25 Feb 2016 10:51:40 GMT

Thank you all for the comments and apologies for the late reply. Unfortunately got side tracked. I ended up finding my error and basically it was where I had the expression to sum the numbers. I have now fixed the issues.