ITERNO()

[qlikview979]

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

[MK_QSL · Accepted solution]

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...

[sushil353]

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

[Anonymous]

Hi mahesh,

For each iteration, InterNo returns number of iteration.

Regards!

[qlikview979]

Hi  Bro,

Thanks,

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

Regards,

Mahesh

[MK_QSL]

Use advanced editor

[qlikview979]

Hi  bro,

Thanks

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