topic Re: Line Chart Problem in QlikView

Line Chart Problem

Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone,

I am having a problem creating a line chart.

I have this table:

Code	Expression
A	42551,534457604
B	42562,565512002
C	42569,561164005
D	42577,518640278

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

My dimension is code.

And i am obtainning this results:

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 !

Re: Line Chart Problem

sunny_talwar — Mon, 08 Aug 2016 16:14:00 GMT

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)

Re: Line Chart Problem

Tue, 09 Aug 2016 08:45:26 GMT

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

Thanks for the help Sunny T.