help

kamalqlik — Tue, 16 Aug 2011 12:43:11 GMT

I wanted to know the solution of following scenario:

There is a table T1 which has Fields code,year,month,value.

For each code for each year,there are 1 or more values:

for eg:

code year month value

1 2010 1 20

1 2010 6 25

if there are no changes in the value for that partucular year, the value

should be same from that particular month till the end of that year.If there

are changes in any particular month,then the value should take effect from

that month till the end of the year.

How to code this?

its_anandrjs — Tue, 16 Aug 2011 13:24:35 GMT

Hi,

You need to conditionally load the data for month and it will be checked by condition on value field and month field.

Anand

topic help in QlikView