Solved: How to show the Max of one column compared to anot... - Qlik Community

Report Inappropriate Content · ‎2012-01-19

I have one table with basicaly 3 columns:

I want a chart that shows for every C, the first DateField for the max B.

I cannot do that in the load script because the Max depends on my selections. So, let's say I select days 7 to 13. This is the records I get:

For that selection, I expect a chart like this:

In the case the Max of column B returns more than one row for the same column C, the Datefield can be the 1st one.

How can I do that?

I am attaching a QVW where I have this data loaded.

Thanks in advance.

swuehl · ‎2012-01-19

Hi,

try using a chart with dimension C, and as expressions:

=max(B)

and

=Date(min(aggr(if(B=max(total<C> B),DateField),C,B,DateField)))

Hope this helps,

Stefan

edit:

If you are not facing multiple Dates for the same max, you could also use

=Date(FirstSortedValue(DateField,-B))

swuehl · ‎2012-01-19

Hi,

try using a chart with dimension C, and as expressions:

=max(B)

and

=Date(min(aggr(if(B=max(total<C> B),DateField),C,B,DateField)))

Hope this helps,

Stefan

edit:

If you are not facing multiple Dates for the same max, you could also use

=Date(FirstSortedValue(DateField,-B))

mkirchhofer · ‎2012-01-19

Hi,

enclose my suggestion.

If(Aggr(NODISTINCT Max(Zahl),Key)=Zahl,Aggr(NODISTINCT Max(Zahl),Key))

regards

Mario

Report Inappropriate Content · ‎2012-01-19

Swuehl,

That worked. Thank you very much!

How to show the Max of one column compared to another column?