Solved: select the max value by date - Qlik Community

Report Inappropriate Content · ‎2011-09-14

Hi,

Need some helps here.

I'm trying to show the max "Rows" value by date.

For example:

The max row for abc.qvw is on 19-09, it should show 23.

then for xyz.qvw, the max row is on 18-09, so it should show 55.

Report Inappropriate Content · ‎2011-09-15

Hi

Please check my attached file.

do let me know if this one help you.

Report Inappropriate Content · ‎2011-09-14

Hi,

Use Maxstring function in place of sum

HTH

Reg,

Shubhu

Report Inappropriate Content · ‎2011-09-14

In fact, i have tried so many possible ways.

None works....

so i suspect, it's either not possible to do it with that structure, or we need to manipulate the data further.

this expression works if only there's only one date row. when u have multiples, it wont work.

MaxString(if(DATE=aggr(maxstring(DATE),QVW),ROWS))

kaushiknsolanki · ‎2011-09-14

Hi,

Have a look at the attachment.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Sokkorn · ‎2011-09-14

Hi,

Try to change from sum(Rows) to max(Rows).

Regards,

Sokkorn

Report Inappropriate Content · ‎2011-09-14

Hi,

Check the attached doc.

Reg,

Shubhu

Report Inappropriate Content · ‎2011-09-14

Hi Kaushik,

Thanks, but i need it in the table.

Report Inappropriate Content · ‎2011-09-14

Hi Shubhu,

Neat, but the data is wrong. the 55 is on 18-09. not 19-09.

Thanks.

kaushiknsolanki · ‎2011-09-14

Hi,

OK have a look at the file.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Report Inappropriate Content · ‎2011-09-14

Hi Kaushik,

Thanks agian, but the max() wont work if we want QVD | DATE | ROWS in the table.

Any other tips?