Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Aggr with set analysis in a line chart

Hello everyone,

I'm new to qlikview and  I need your help.

What I have:

    

Status checkpointdatenproblems
2A20-out10
2B21-out35
2B24-out10
2B25-out20
3A25-out10
3B30-out20

Line chart:

Dimension:

status

expression used:

sum(aggr(-(max({<checkpoint={'B'}>} date) - min({<checkpoint={'A'}>} date) > 3),Status, nproblems)) 


when i have the status filter selected it shows me the number of problems that i have to solve and that are exceeding the SLA(-(max({<checkpoint={'B'}>} date) - min({<checkpoint={'A'}>} date) > 3).

If I select status 2 it appears on the chart line the number 30. If I select status 3 it shows on the chart line the number 20.  Meaning that if i choose in my filters just one status it gives me the correct result for that status.


My problem: the filter status has to have always one value selected and my client wants to see in a line chart the evolution of the status selected regarding the last 3 status(1,2,3,4).

So, if i have the status 3 selected, it must appear in the line chart the information regarding the status 3 and 2 for the table that I indicated above.

I think that the main problem is regarding the date, because it is always different and unpredictable and its used in the expression.

Can you help me finding a solution for this?

Best regards,

Joana



0 Replies