topic How to display the value? in QlikView

How to display the Maxvalue?

Fri, 09 Sep 2011 15:44:02 GMT

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

How to display the value?

IAMDV — Fri, 09 Sep 2011 15:52:16 GMT

Sorry, I am not very clear with your question. But with my understanding you can use the Only() Function. I,e. you can use Only(Lot) as long as you are selecting one date at a time.

Please explain in more detail with example if this not what you need.

Cheers - DV

Re: How to display the value?

Fri, 09 Sep 2011 15:56:46 GMT

Hi Dv,

Thanks for your reply

In my sample file I have two fields those are Days and Lot

Now i need to display the maximum value of Days field corresponding Lot in a Textobject by default (i don't want to select the maxvalue from the Days field) that means when ever the reloading is happened.

Can i do like this?

Thanks..

How to display the value?

its_anandrjs — Fri, 09 Sep 2011 15:57:34 GMT

Hi,

Please clear what is your requirement in details it is not clear what do you mean by corresponding lot for that date by default.

Already in your example it shows when you select any date its coresponding data in lot list box.

Regards

Anand

Re: How to display the value?

Fri, 09 Sep 2011 16:01:13 GMT

Hi Anand,

Thanks for your reply

Please see the reply for DV's post.

Thanks..

How to display the Maxvalue?

its_anandrjs — Fri, 09 Sep 2011 16:08:06 GMT

Hi,

Can you explain with any text example.

Regards,

Anand

Re: How to display the Maxvalue?

Fri, 09 Sep 2011 16:23:36 GMT

Anand,

please see the attachment

in this i am getting Maxlot for the entire Lot field.But not for the Max(Days).

What i am asking is

If i take max(Days) in a textobject,it will display that max value .similarly for Lot also.

But what i need here is not the Max(Lot) from the entire Lot field.I need only the lot to be displayed for that maxdate in a textobject after reloading the file.

In future my data increases automatically then maxdate changes,so, i can get that corresponding lot in the textobject too.

Ex:

Day,Lot

9-8-11 ,1

10-8-11 ,3

11-8-11 ,5

12-8-11 ,8

13-8-11 ,4

In UI, I mamy take two Textobjects for to display the max(Day) and Max(Day)'s lot(This thing i need).

The problem here is i dont want the maxlot .I want only the Lot for that maxDay.

Thanks..

Re: How to display the Maxvalue?

Mon, 12 Sep 2011 05:51:14 GMT

Hi DV and Annand,

Please see the attached file.

Now you can understand how i want.

Please comment for one table and uncomment another table and reload the file and observe the text objects.

Thanks..

Re: How to display the Maxvalue?

Mon, 12 Sep 2011 06:40:35 GMT

Hi. In your attached example I understand that you want the textbox to display 21 right?

But what happens if this is your data:

Day,Lot

9-8-11 ,1

10-8-11 ,3

11-8-11 ,5

12-8-11 ,8

13-8-11 ,4 <- SAME DAY, DIFFERENT LOT

13-8-11, 2 <- SAME DAY, DIFFERENT LOT

Do you then want the max(lot) out of the two possible ones on he day 13-8-11?

The only solution I would know to solve this task is by making a small macro macro that is activated after reload (1. select max date, 2. get possbile values from the lot field 3. take the max from those 4. return that max into a variable 5. display the variable in the textbox - but perhaps there is a easier solution?

/Robert

Re: How to display the Maxvalue?

rohit214 — Mon, 12 Sep 2011 06:54:28 GMT

hey ravi kumar

i modified ur file .

just go through it.

may it helps you

thanks

rohit

Re: How to display the Maxvalue?

kaushiknsolanki — Mon, 12 Sep 2011 07:42:31 GMT

Hi,

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

Regards,

Kaushik Solanki

Re: How to display the Maxvalue?

Mon, 12 Sep 2011 07:48:28 GMT

Kaushik,

Yes Ineed MaxLot for the MaxDate.

Thanks...

Re: How to display the Maxvalue?

Mon, 12 Sep 2011 07:52:47 GMT

Rohit,

Not like that .

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

Thanks..

Re: How to display the Maxvalue?

kaushiknsolanki — Mon, 12 Sep 2011 07:57:10 GMT

Hi,

Try this.

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

Use this in text box.

Regards,

Kaushik Solanki

Re: How to display the Maxvalue?

Mon, 12 Sep 2011 10:22:26 GMT

Hi All

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

Thanks.

Re: How to display the Maxvalue?

Anonymous — Mon, 12 Sep 2011 12:18:15 GMT

Hi Ravi,

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

Cheers.

Ad.