Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
surajap123
Creator II
Creator II

cal field on many to many


Hi Experts,

I have 2 tables with many to many relation and i want to create a calculated field.

In Field Loc, for the value TKT the Zone field value should be changed to ME for Date later than 01/05/2016. So any data before that should be unchanged.

if(Loc = 'TKT' AND Date >= 01/05/2016, 'ME', Zone) as Zone


To create a calculated field on Dim table, the date field is require. Both the tables are many to many relation, so joining is not the write solution.

I though of creating a flag to identify the max Date available in the model for the value TKT. But not sure how to achieve this.

Please help.

1 Reply
surajap123
Creator II
Creator II
Author

Please provide some inputs. It would be very helpful.