topic Re: I am using correct script?? in QlikView

I am using correct script??

harleen_singh — Wed, 13 Jul 2011 06:07:35 GMT

I don't know where i am wrong in this script??

LOAD date,

Max(date) as maximumdate

FROM

table

thanks

Lavi

I am using correct script??

Wed, 13 Jul 2011 06:12:57 GMT

Hi,

Check with 'Group By"

-Jai

I am using correct script??

harleen_singh — Wed, 13 Jul 2011 06:17:39 GMT

I have used this

LOAD date,

Max(date) as maxidate

FROM

table

Group by date;

it didn't worked

Re: I am using correct script??

Wed, 13 Jul 2011 06:19:20 GMT

Hi,

the load statement should be like this:

LOAD date,

Max(date) as maximumdate

FROM

table

Group by date, v;

Cheers.

I am using correct script??

harleen_singh — Wed, 13 Jul 2011 06:26:39 GMT

blackrocks

you are correct but max function is not retrieving maximum date its displaying all dates as usual.

thanks

Re: I am using correct script??

Wed, 13 Jul 2011 06:29:11 GMT

Hi,

is it possible for you to attach sample data that you are loading.

Re: I am using correct script??

Wed, 13 Jul 2011 06:29:33 GMT

Hi,

Check with the appln

-Jai

I am using correct script??

kaushiknsolanki — Wed, 13 Jul 2011 06:29:39 GMT

Hi,

Remove the date field if you want only max(date) and the value of v.

something like this.

load v,max(Date) as MaxDate

from table

group by v;

If you just want to have max(date) which is not linked to the table. then try this.

load max(Date) as MaxDate

from table

Regards,

Kaushik Solanki

Re: I am using correct script??

harleen_singh — Wed, 13 Jul 2011 06:34:18 GMT

Black Rocks

its simple

date v

10/7/2011 1

11/7/2011 2

12/7/2011 3

Re: I am using correct script??

harleen_singh — Wed, 13 Jul 2011 06:51:05 GMT

I want to display maximum date as well as all dates as well as all values(v).

thanks

I am using correct script??

kaushiknsolanki — Wed, 13 Jul 2011 06:58:35 GMT

Hi,

As per my knowledge its not possible to have date, max(date) together.

Let me explain.

Cosider you have data like this

date v

10/7/2011 1

11/7/2011 2

12/7/2011 3

10/8/2011 4

11/8/2011 5

12/8/2011 6

So here max of date will be 12/08/2011

but according to your requirement i.e you want Date Max(Date) and v

this will give you the result like this only.

date Max(Date) v

10/7/2011 10/7/2011 1

11/7/2011 11/7/2011 2

12/7/2011 12/7/2011 3

10/8/2011 10/8/2011 4

11/8/2011 11/8/2011 5

12/8/2011 12/8/2011 6

i hope you understood what i mean to say.

if not then please exaplain with example, give the raw data as well as the output you want.

Regards,

Kaushik Solanki

Re: I am using correct script??

harleen_singh — Wed, 13 Jul 2011 07:06:46 GMT

kaushik

raw data is same u have written

i want output like this

date Max(Date) v

10/7/2011 12/8/2011 1

11/7/2011 12/8/2011 2

12/7/2011 12/8/2011 3

10/8/2011 12/8/2011 4

11/8/2011 12/8/2011 5

12/8/2011 12/8/2011 6

I am using correct script??

perumal_41 — Wed, 13 Jul 2011 07:10:19 GMT

use this script ;Check is correct or not

LOAD date,

FROM

table

left Join

load v,max(Date) as MaxDate

from table

group by v;

I am using correct script??

kaushiknsolanki — Wed, 13 Jul 2011 07:28:32 GMT

HI,

Try this script.

Data:

load * inline [

date, v

10/7/2011, 1

11/7/2011, 2

12/7/2011, 3

10/8/2011, 4

11/8/2011, 5

12/8/2011, 6

];

Max:

load

max(date) as MaxDate

Resident Data ;

let Max_Date = peek('MaxDate',0,'Max');

Data1:

load

date as Date,

date($(Max_Date)) as Max_Date,

v as V

Resident Data;

Drop table Data, Max;

Regards,

Kaushik Solanki

Re: I am using correct script??

harleen_singh — Wed, 13 Jul 2011 11:24:23 GMT

Kaushik

thanks this is correct but again when i am clicking on max_date corresponding data is not changing according to maximum date.

click on max_date in attach file u will know

thanks

Lavi

Re: I am using correct script??

kaushiknsolanki — Wed, 13 Jul 2011 11:36:24 GMT

Hi,

Its is selecting corresponding data.

I will explain you how it works.

See now you got result as

date Max(Date) v

10/7/2011 12/8/2011 1

11/7/2011 12/8/2011 2

12/7/2011 12/8/2011 3

10/8/2011 12/8/2011 4

11/8/2011 12/8/2011 5

12/8/2011 12/8/2011 6

right..?

So you will have 3 fields i.e Date which will have values from 10/7/2011 to 12/08/2011

Second field will be Max(Date) which will have only one value i.e 12/08/2011

and third will be v which will have 1 to 6.

Now as you said when you like on 12/08/2011 nothing is selected in Date and Value field.

so even if you select max(date) there will be no change on other field and vice versa.

The reason is max(date) is available in all fileds and max(date) is having only one value.

If incase you had data like this.

date Max(Date) v

10/7/2011 12/7/2011 1

11/7/2011 12/7/2011 2

12/7/2011 12/7/2011 3

10/8/2011 12/8/2011 4

11/8/2011 12/8/2011 5

12/8/2011 12/8/2011 6

Then your max(date) field will have two values and now the selection in max(date) will effect the other fields too.

But you cant use the same script to get the data shown above. You need to think on it to get the same data as shown above.

I hope your doubt is clear now.

Regards,

Kaushik Solanki