topic Re: First and Last value in QlikView

First and Last value

Mon, 11 Aug 2014 07:43:27 GMT

Hi all.

I have a table:

Date	Value 1	Value 2
01-01-2014	1	-
02-01-2014	2	-
03-01-2014	1	2
04-01-2014	4	-
05-01-2014	1	-
06-01-2014	6	-
07-01-2014	2	-
08-01-2014	8	4
09-01-2014	5	-
10-01-2014	6	-

I want see:

1) In first text object - first value on column "Value 2" - that is "2"

2) In second text object - last value on column "Value 2" - that is "4"

I have a NULL value (or non value) in column "Value 2"!!!

Any idea how it do?

I need use function: FirstSortedValue([Value 2], Date) ???

But i see "-".

Thank you.

Re: First and Last value

amit_saini — Mon, 11 Aug 2014 07:49:05 GMT

Dmitry,

Try this:

Checked "Suppress When Value us Null " option and see the result.

Thanks,
AS

Re: Re: First and Last value

Mon, 11 Aug 2014 08:09:27 GMT

Amit, thank you.

But it works in Pivot table.

I need in different text object:

2

4

Re: First and Last value

tresB — Mon, 11 Aug 2014 08:20:26 GMT

Try like:

FirstSortedValue({<[Value 2]-={'-'}>}[Value 2],Date) , and

FirstSortedValue({<[Value 2]-={'-'}>}[Value 2],-Date)

Re: First and Last value

ashfaq_haseeb — Mon, 11 Aug 2014 08:23:08 GMT

Hi,

May be like this.

Regards

ASHFAQ

Re: First and Last value

simenkg — Mon, 11 Aug 2014 08:24:40 GMT

in your script, create a flag:

load

...

if(isnull(Value 2), 0,1) as ValidValue2Flag,

...

From Input.

Then you use

FirstSortedValue({$<ValidValue2Flag={1}>}[Value 2],Date)

Re: Re: First and Last value

Mon, 11 Aug 2014 08:26:05 GMT

Tresesco Thank you!

It work.

Can you explain me this expression: {<[Value 2]-={'-'}>}

I'm confused by in the signs...