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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Line Chart Problem

Hello everyone,

I am having a problem creating a line chart.

I have this table:

Code Expression
A42551,534457604
B 42562,565512002
C 42569,561164005
D42577,518640278

My expression is : = Max(aggr(Max({$<status={'running'}>}Max_ClientStatus_Time),code)).

My dimension is code.

And i am obtainning this results:

QlikPergunta.png

when  I choose one code, it gives me the right result, when I don't select any code it gives me the max value to all codes. I can't understand why. Can anyone help me?

Greetings !

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar
MVP
MVP

Do you have another dimension? If code is your only dimension, why don't you need Aggr() function here? can you try this:

Max({$<status={'running'}>}Max_ClientStatus_Time)

View solution in original post

2 Replies
sunny_talwar
MVP
MVP

Do you have another dimension? If code is your only dimension, why don't you need Aggr() function here? can you try this:

Max({$<status={'running'}>}Max_ClientStatus_Time)

Not applicable
Author

It worked using the expression Max({$<status={'running'}>}Max_ClientStatus_Time).

Thanks for the help Sunny T.