Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
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

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

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?