topic Re: Chart & Graph differences in QlikView

Chart & Graph differences

Wed, 10 Feb 2016 10:01:49 GMT

Dear Community,

I'm trying to create a combo graph with a bar and line graph but something strange is happening. If I display my information as a chart I get the below table:

But when I put this into a graph I get this:

The expression causing me issues is below:

=sum(aggr(max(if(DateClosed>=addmonths(vStartDate,-11) AND DateClosed<=vEndDate,LineQty)),ShipmentId))

If you hover over that line it shows different data points but they aren't correlating to the dimension

=MonthName(floor(DateClosed))

Any ideas?

Re: Chart & Graph differences

sunny_talwar — Wed, 10 Feb 2016 10:04:13 GMT

Would you be able to share a sample?

Re: Chart & Graph differences

marcus_sommer — Wed, 10 Feb 2016 11:21:06 GMT

Your aggr included not the dimension from chart. This wouldn't work in your case because it's a calculated dimension - suggestion here is to create all needed period-fields within a master-calendar: How to use - Master-Calendar and Date-Values - further noticeable is that you used floor for your DateClosed which indicates that it is timestamp, to compare dates with timestamps is possible but unnecessary error-prone.

- Marcus