Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a field, fiscal_year, which links two of my datasets. In one dataset the values range from 2010-2013, and in the other they range from 2010-2019. As part of a conditional statement, I would like to reference both tables' values separately. Essentially, I would like to say, "If fiscal_year in Table1 is equal to fiscal_year in Table2, then____________." Obviously I cannot just use the field name, because the values in the two datasets differ in their range.
Thanks!
[Edited the title to clarify]
Marco, I think the problem here is a more fundamental understanding of QlikView. QV utilizes an associative data model. From a data point of view, it does not matter which table a field value is in--QlikView itself only sees memory pointers and associations. Because of this, it's not possible to compare the same field's values in one table to the values in another. You would need to find another field that returns the condition you are looking for. Paste a few rows from your table, along with the desired output, and someone on here will try to help you out.
Regards,
Vlad
Marco, I think the problem here is a more fundamental understanding of QlikView. QV utilizes an associative data model. From a data point of view, it does not matter which table a field value is in--QlikView itself only sees memory pointers and associations. Because of this, it's not possible to compare the same field's values in one table to the values in another. You would need to find another field that returns the condition you are looking for. Paste a few rows from your table, along with the desired output, and someone on here will try to help you out.
Regards,
Vlad
Thanks Vlad - you're right that I didn't understand that aspect of QV. I found a workaround solution and am working to make that perfect right now, so thank you for your guidance.
No problem, post back on here if you encounter any problems.
Vlad
Hi Vlad - my current question is here: