Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with Set Analysis and Max

I have a problem, that cant solve.

I have this table

Ticket Count Date Status Side
1000 1 Feb 2013 Open Me
1000 2 Feb 2013 Question Client
1000 3 Mar 2013 Process Me
1001 1 Feb 2013 Open Me
1001 2 Feb 2013 Question Client
1002 1 Mar 2013 Open Me
1002 2 Mar 2013 Question Client
1002 3 Jul 2013 Process Me
1003 1 Jul 2013 Open Me
1003 2 Jul 2013 Process Me

What I need is a Bar Chart with 2 columns (Me and Client)  discriminated by month/year. Where I have to show How many tickets do I have for each month, but only I have to Count the last status ( the Max Count field)

So based on this example:

Should be 4 in total, cause I have only 4 distinct tickets, 1 in "Client" on Feb 2013, 1 in "Me" on Mar 2013, and the last 2, 1 in "Me" and 1 in "Client" on Jul 2013

I cant find the way to only show the last status for each ticket, It can be solved only with set analysis or I should have to use aggr ?

I leave the example.

Thx

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

See attached qvw


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

See attached qvw


talk is cheap, supply exceeds demand
Not applicable
Author

Thx, cant believe it was that simple. It seems I have a real problem undestanding when to use expression and when dimension.