Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

cbaqirdhds
Valued Contributor

Pivot table doesn't match line chart

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)


2019-01-24_12-52-18.jpg

1 Solution

Accepted Solutions
Highlighted

Re: Pivot table doesn't match line chart

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))
4 Replies
Highlighted

Re: Pivot table doesn't match line chart

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))
MindaugasBacius
Valued Contributor II

Re: Pivot table doesn't match line chart

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:

Screenshot_3.jpg

cbaqirdhds
Valued Contributor

Re: Pivot table doesn't match line chart

I need both expressions.

cbaqirdhds
Valued Contributor

Re: Pivot table doesn't match line chart

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