topic Re: Pivot table doesn't match line chart in QlikView

Pivot table doesn't match line chart

cbaqir — Thu, 24 Jan 2019 19:56:48 GMT

In the example in this image, I would expect to see the line chart show one ticket submitted for 12/10 and one for 1/07, just like in the pivot table. What am I missing?

Dimension: =aggr(max( {$<COM_CAT={'ART - Agenda'}>}WeekStart(COM_CAT_START_DATE)),COM_CAT_START_DATE)

Re: Pivot table doesn't match line chart

sunny_talwar — Thu, 24 Jan 2019 20:03:20 GMT

May be you forgot to add this to your expression

=sum(if(aggr(count({$<COM_CAT={'ART - Agenda'}>}COM_CAT),DEFECT_ID,COM_CAT_START_DATE)>=1,1))

Re: Pivot table doesn't match line chart

MindaugasBacius — Thu, 24 Jan 2019 20:08:12 GMT

I have simple cloned the Pivot table and instead of Pivot table changed to Line chart.

Also removed one of the expression and the result is:

Re: Pivot table doesn't match line chart

cbaqir — Thu, 24 Jan 2019 20:27:17 GMT

I need both expressions.

Re: Pivot table doesn't match line chart

cbaqir — Thu, 24 Jan 2019 21:10:49 GMT

How would I get the 100% to show on the 2nd occurrence since the first time it came through it wasn't a repeat?