How to display the Maxvalue? - Page 2 - Qlik Community

Report Inappropriate Content · ‎2011-09-09

Hi all,

I have a problem

Please help me to sole it.

Here i am attaching one sample file.Please go through this.

I am able to display max value for Days field in a textobject by default.But how can i display the corresponding lot for that date by default.

Thanks for any help...

kaushiknsolanki · ‎2011-09-12

Hi,

Do you mean that you need max Lot for Max Date?

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-12

Kaushik,

Yes Ineed MaxLot for the MaxDate.

Thanks...

Report Inappropriate Content · ‎2011-09-12

Rohit,

Not like that .

Here the maxlot is displaying only when ever the date is selected.I need without selecting the date.

Thanks..

kaushiknsolanki · ‎2011-09-12

Hi,

Try this.

=Max({<Date= {"$(=Max(Date))"}>}Lot)

Use this in text box.

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-12

Hi All

Here i am attaching the solution for my problem.Please go through it.

Thanks.

Anonymous · ‎2011-09-12

Hi Ravi,

You may need expand on what you are trying to achieve.

Cheers.

Ad.