topic Re: ITERNO() in QlikView

ITERNO()

qlikview979 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

In "date" field i have 1/1/2016 and dates field having 1/30/2016 .

T1:

LOAD

date,

Date(date+IterNo()-1) as DATE,

dates

FROM

(ooxml, embedded labels, table is Sheet5)

While date+IterNo()-1<=dates;

now i am using this code i got missing dates fine.

Here my Doubt is how itreno() will work. how it generates dates.

Regards,

Mahesh

Re: ITERNO()

MK_QSL — Tue, 21 Jun 2016 09:52:13 GMT

IterNo() = 1 when the first iteration is going on...

You are now using IterNo() - 1 which is 0 for 1st Iteration and 1 for 2nd iteration and so on.

This you are adding to your date field...

so for 1st Iteration date would be date + 1 - 1 = date + 0 which will remain same

for 2nd iteration date would be date + 2 - 1 = date + 1 which will be the next date..

so on..

the iteration will go on until

date + IterNo() - 1 <= dates...

Re: ITERNO()

sushil353 — Tue, 21 Jun 2016 09:53:35 GMT

ITERNO() is just adding a numerical value starting from 1 with an increment of 1 in every row processing.

so this is added to your date and generates the next date.

HTH

Re: ITERNO()

Anonymous — Tue, 21 Jun 2016 09:57:54 GMT

Hi mahesh,

For each iteration, InterNo returns number of iteration.

Regards!

Re: ITERNO()

qlikview979 — Tue, 21 Jun 2016 09:58:58 GMT

Hi Bro,

Thanks,

I have one doubt How can i add color script in community.

Regards,

Mahesh

Re: ITERNO()

MK_QSL — Tue, 21 Jun 2016 10:24:52 GMT

Use advanced editor

Re: ITERNO()

qlikview979 — Tue, 21 Jun 2016 10:28:49 GMT

Hi bro,

Thanks

I have posted one more question please check that main Difference between Autogenarate & Iterno() ?