topic Re: [ask] show first and last data each second in QlikView

[ask] show first and last data each second

Thu, 01 Mar 2012 09:13:04 GMT

hello qlikview world

i wanna ask a problem that i can't solve

i have 3 column : premary key, time, price

and i want to show the first and last data each second

it will show something like below :

time	premary key	first	last
14:56:20	195	142	-
14:56:20	200	-	142
14:56:34	186	142	-
14:56:34	194	-	142
...
...
...
15:04:07	165	144	-
15:04:07	167	-	144

how to do that?

many thx....

[ask] show first and last data each second

CELAMBARASAN — Thu, 01 Mar 2012 09:17:27 GMT

Hi,

Are you expecting this in load script or in presentation?

Celambarasan

[ask] show first and last data each second

Thu, 01 Mar 2012 09:23:52 GMT

halo celambarasan..

i want to show this in presentation of qlikview

[ask] show first and last data each second

CELAMBARASAN — Thu, 01 Mar 2012 09:26:26 GMT

Hi,

If you are need this in load try this.

Table:

Load

time,

premary key,

price

From ..

OutPut:

Load

time,

FirstValue(premary key) as FirstPremaryKey,

LastValue(premary key) as LastPremaryKey,

FirstValue(price) as first,

LastValue(price) as last

Resident

Table;

Hope it helps

Celambarasan

[ask] show first and last data each second

CELAMBARASAN — Thu, 01 Mar 2012 09:28:27 GMT

Hi,

Can you upload the sample data to work with it?

Celambarasan

Re: [ask] show first and last data each second

Thu, 01 Mar 2012 09:35:36 GMT

hi...

i've tried yours but it shows error :

Invalid expression

source_filter:

Load

Time,

FirstValue(Premary_Key) as FirstPremaryKey,

LastValue(Premary_Key) as LastPremaryKey,

FirstValue(Price) as firstprice,

LastValue(Price) as lastprice

Resident source

many many thx

[ask] show first and last data each second

sridhar240784 — Thu, 01 Mar 2012 09:38:38 GMT

Hi,

You have missed your group by clause.

source_filter:

Load

Time,

FirstValue(Premary_Key) as FirstPremaryKey,

LastValue(Premary_Key) as LastPremaryKey,

FirstValue(Price) as firstprice,

LastValue(Price) as lastprice

Resident source

Group by Time;

-Sridhar

Re: [ask] show first and last data each second

CELAMBARASAN — Thu, 01 Mar 2012 09:38:38 GMT

Hi,

Sorry i forget to add Group by clause in it because first value and last value function will work only with group by.

source_filter:

Load

Time,

FirstValue(Premary_Key) as FirstPremaryKey,

LastValue(Premary_Key) as LastPremaryKey,

FirstValue(Price) as firstprice,

LastValue(Price) as lastprice

Resident source Group by Time;

It will work.

Celambarasan

Re: [ask] show first and last data each second

Thu, 01 Mar 2012 09:42:14 GMT

many thx for both of you..

many many thx...

may god with you