topic Re:Firstsortvalue on a Dinamic Table in QlikView

Firstsortvalue on a Dinamic Table

Mon, 06 Dec 2010 18:35:03 GMT

Hello Experts,

I need a function similar to Firstsortvalue() does in Script, for to put on a Dimension or Expression Dinamic table. like this example

My data are

Field 1 | Field 2

1 | A

1 | B

2 | D

2 | C

And I Want the result on a Dinamic Table:

Field 1 | Field 2

1 | A

2 | D

Just the first Field 2 data for Field 1

Is it Possible?

Tks Experts

spividori — Mon, 06 Dec 2010 20:22:40 GMT

Hi.

In the scripts you can use

Table1:

Load Field1 as FirstValue1,

Field2 as FirstValue2,

if(Field1=previous(Field1),0,1) as Check

resident Table

oreder by Field1;

And then select the records where the Check is 1.

Regards.

pover — Tue, 07 Dec 2010 03:50:47 GMT

You can also try the following:

Table1:

Load rowno() as Order,

Field1,

Field2

resident Table

and then the expression would be firstsortedvalue(Field2,Order).

There's also a firstvalue() function for the script that you would use with a Group by Field1.

Regards.

Tue, 07 Dec 2010 11:00:24 GMT

Ok, But is it possible do this on an expression into a Dinamic table? or on a Dimension Calculated?

Tue, 07 Dec 2010 13:55:06 GMT

TKS Experts I using the function Maxstring()

Its Ok