Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

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

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))

View solution in original post

4 Replies
Highlighted

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))

View solution in original post

Highlighted
Specialist III
Specialist III

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

Highlighted
Specialist
Specialist

I need both expressions.

Highlighted
Specialist
Specialist

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