Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Valued Contributor


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?

1 Reply



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


Community Browser