topic Re: Can we create a expression with counter ? in QlikView

Can we create a expression with counter ?

chiru_thota — Fri, 24 Oct 2014 18:27:14 GMT

Hi all,

Can I get the below expression as highlighted in red.

Basically I am trying to start my counter at 1 and continue till I see null.....same thing repeats but it should from 1 again continue (1,2,3...).

Is this possible some how ?

chiru_thota — Mon, 27 Oct 2014 14:08:15 GMT

Any Ideas ?

jonathandienst — Mon, 27 Oct 2014 14:15:56 GMT

Counter:

=If(IsNull(Above([Value])), 1, Above([Counter]) + 1)

=If(IsNull([Value]), null(), If(IsNull(Above([Value])), 1, Above([Counter]) + 1))

HTH

Jonathan

chiru_thota — Mon, 27 Oct 2014 14:56:28 GMT

Thanks Jonathan.

You are real guru!

Thanks,

Chiru