Problem with Set Analysis and Max

Thu, 23 May 2013 03:49:16 GMT

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

Re: Problem with Set Analysis and Max

Gysbert_Wassenaar — Thu, 23 May 2013 10:46:22 GMT

See attached qvw

Re: Problem with Set Analysis and Max

Thu, 23 May 2013 13:24:01 GMT

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

topic Re: Problem with Set Analysis and Max in QlikView

Problem with Set Analysis and Max

Re: Problem with Set Analysis and Max

Re: Problem with Set Analysis and Max