topic Re: Mark a serial score in a column by one score using script in QlikView

Mark a serial score in a column by one score using script

Wed, 25 Nov 2020 16:16:04 GMT

Dear all,

See here the 'problem'

First column contains observation number.

Second column Class contains scores 'Y'.

What I would like to get:

A field 'Output' where only one 'Y' is visible as representative for the groups of 'Y'.The empty space in the previous cell in field Class marks the position of 'Y' in the cell of field Output.

I suppose that shoudl be solved using peek function, but could you demonstrate an efficient solution?

Thanks,

Cornelis.

Re: Mark a serial score in a column by one score using script

Gysbert_Wassenaar — Thu, 18 Aug 2016 14:15:36 GMT

LOAD

Obs,

Class,

If(Class='Y' and Previous(Class) <> 'Y', Y) as Output

FROM

...source data...

;

Re: Mark a serial score in a column by one score using script

Thu, 18 Aug 2016 17:45:02 GMT

Hi Gysbert,

That is indeed the best solution and apparently very easy.

A little correction:

If(Class = 'Y' and Previous(Class) <> 'Y', 'Y') as Output

not Y but 'Y'.

Best regards,

Cornelis