Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Highlighted
cbaqirdhds
Contributor II

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
Contributor II

Re: Pivot table doesn't match line chart

I need both expressions.

cbaqirdhds
Contributor II

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?
Community Browser