Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can we access some particular value from a calculated dimension using loop?

Hello Everyone,

Need your Help.

How can we access some particular value from a calculated dimension using loop?

Like I have a TableA

Field1     Field2     Field3

A               01-10-2013          2000

B               02-03-2013          1000

C               03-10-2013          4000

A               01-11-2013          (2000 comes from above date value)+some other field

B               03-04-2013          (1000 picked same as above)+some other field

C               03-11-2013          (4000 same as above)+some other Field

where my field 3 is calculated column.
Problem is that i have initial dates value present in this column as the next date come it access its previous given or calculated value to calculate next one.

This synario goes on,

Can we use looping or conditional access for this purpose.

Or do we have another method to pick this value.

Thanks and Regards.

10 Replies
Not applicable
Author

Thanks Jagan,