topic Re: Previous first row in QlikView

Previous first row

stabben23 — Tue, 29 Aug 2017 06:18:48 GMT

Hi,

I have a problem building a flag in script. I have use previous and get a correct output, expect first row.

Here is my table.and this is for changeflag if(previous(dimension)=dimension ,0,1)

What I want is to get a 1 on the first row With a New Dimension. I think that the first 1 will be there because previous find null and compare it With the first row.

Any trix to avoid this scenario?

Re: Previous first row

ksomosera10 — Tue, 29 Aug 2017 06:25:45 GMT

Hi,

I think you'll have to use a calculated dimension

for example is like this.

=if(field2='field2value',field1)

Is that good or not?

Re: Previous first row

stabben23 — Tue, 29 Aug 2017 06:32:11 GMT

Hi Kevin,

this is in script not in a pivot.

Re: Previous first row

ksomosera10 — Tue, 29 Aug 2017 06:34:30 GMT

So you're sayin' this is on the load script?

Re: Previous first row

kenphamvn — Tue, 29 Aug 2017 06:41:54 GMT

using RowNo() like a trick

if(previous(dimension)=dimension or rowno() =1 ,0,1)

Re: Previous first row

antoniotiman — Tue, 29 Aug 2017 06:42:12 GMT

Hi Staffan,

maybe this

if(previous(dimension)=dimension or RowNo()=1 ,0,1)

Regards,

Antonio

Re: Previous first row

tresB — Tue, 29 Aug 2017 06:44:08 GMT

You can perhaps just try putting rowno()=1 check like:

if(if rowno()=1 or previous(dimension) <> dimension ,1 , 0)

Re: Previous first row

stabben23 — Tue, 29 Aug 2017 06:49:26 GMT

Three similar answer, let give it a try.

Re: Previous first row

stabben23 — Tue, 29 Aug 2017 07:04:14 GMT

The rowno() check will help me, thanks guys.