topic loop through the current table to generate a new column in QlikView

loop through the current table to generate a new column

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

I have a table in the below structure and I want to generate one more column from the below that satisfying the below condition

The name of the column is called Dividend_paid since 01/01/2016.

The rule is to search For the same ASX code and add up last column(Dividend_Paid) if the date is between 01/01/2016 and the corresponding value in Date column. I think something loop will do the job, but not exactly how. thanks

Re: loop through the current table to generate a new column

Anil_Babu_Samineni — Wed, 22 Nov 2017 04:00:15 GMT

I wonder, why loop helps here. Some where try this?

If([ASX code] = Previous([ASX code]) and (Date >= MakeDate(2016,01,01) and Date <= Previous(Date)),'Flag1', 'Flag2') as Dividend_Paid

Re: loop through the current table to generate a new column

woshua5550 — Wed, 22 Nov 2017 04:17:07 GMT

try this

Load *,

IF([ASX Code] = Previous([ASX Code]) And Date >= MakeDate(2016,1,1) And Date <= Previous(Date),Dividend_Paid + Previous(Dividend_Paid) As Dividend_Paid

From <TableName>

Order by [ASX Code]