topic Re: Expression Help in QlikView

Expression Help

abhaysingh — Thu, 24 Sep 2015 05:10:01 GMT

HI All,

I have a table in Which i m getting Number of Temperature Values.

i want to pick Last Record from that temperature field.

I am using Expression like that in a table

Table:

load

Field1,

Field2,

Temperature,

Peek(Temperature,-1,'Table') as CurrentTemperature

From Path..

But not getting the expected output.

Regards

Abhay

Re: Expression Help

sunny_talwar — Thu, 24 Sep 2015 05:16:14 GMT

May be this:

Table:

load

Field1,

Field2,

Temperature,

FROM Source;

LastTemp:

LOAD LastValue(Temperature) as CurrentTemperature

Resident Table;

Re: Expression Help

abhaysingh — Thu, 24 Sep 2015 05:24:42 GMT

Hi Sunny,

Its not Working with multiple field...

How I will Link it to my Table.

Re: Expression Help

sunny_talwar — Thu, 24 Sep 2015 05:27:05 GMT

Would you be able to share a sample with expected output?

Re: Expression Help

abhaysingh — Thu, 24 Sep 2015 05:30:15 GMT

I can Explain you

Table:

load

Asset,

Field2,

Temperature,

FROM Source;

This is kind of table i have and Assets has multiple temperature which is stored in Temperature Field

So I need to Pick Last Temperature as Current Temp of Asset.

Asset Temp

ABC -20

ABC -10

ABC -5

ABC 1

So Against ABC i Want 1 as Output.

Regards

Abhay

Re: Expression Help

sunny_talwar — Thu, 24 Sep 2015 05:33:17 GMT

If you have multiple assets, try this:

Table:

LOAD Asset,

Temperature,

FROM Source;

Join (Table)

LOAD Asset,

LastValue(Temperature) as CurrentTemperature

Resident Table

Group By Asset;

Re: Expression Help

sunny_talwar — Thu, 24 Sep 2015 05:37:48 GMT

See if this works:

Table:

LOAD * Inline [

Asset, Temp

ABC, -20

ABC, -10

ABC, -5

ABC, 1

DEF, -20

DEF, -10

DEF, -5

DEF, 10

];

Join (Table)

LOAD Asset,

LastValue(Temp) as CurrentTemp

Resident Table

Group By Asset;

Re: Expression Help

petter — Thu, 24 Sep 2015 06:15:23 GMT

I would suggest this approach - with a normal link (association) so you get efficient storage and quick execution:

Re: Expression Help

sunilkumarqv — Thu, 24 Sep 2015 06:15:47 GMT

Its working

Data:

LOAD FirstSortedValue(Temp,-RecNo()) as Lastvalue;

LOAD * Inline

[Asset,Temp

ABC,-20

ABC,-10

ABC,-5

ABC,1

];