topic Struggling With Expression - Two Different Tables in QlikView

Struggling With Expression - Two Different Tables

pnn44794 — Wed, 25 Nov 2020 16:16:04 GMT

Hello All:

I'm struggling with an expression where it works fine in one table, but not another table where I need, effectively, the same expression executed. I suspect I'm missing something simple. This is in a straight table where I'm trying to do this. For simplicity, I'll call the tables TableA and TableB.

This works fine in TableA. In TableB, it only returns a blank column. I'm guessing that I need to have at least one column related to both tables, but I'm struggling to come up with one (have tried multiple different columns).

TableA has columns Product, Q1, Q2, Q3, Q4 Consumed which are all expressions and which I'm trying to calculate for TableB, etc.

TableB has columns ProductGroup, DM #, order_date_quarter, =Table1_order_date_quarter = v2018ForecastQtr, =v2018ForecastQtr, and Product2018.

Does anyone have any ideas? As always, thanks in advance for any and all help / responses.

Re: Struggling With Expression - Two Different Tables

Anil_Babu_Samineni — Mon, 27 Aug 2018 07:09:30 GMT

You may change Product / ProductGroup to maintain consistency each associate. Then, Try? Or share your model please

Re: Struggling With Expression - Two Different Tables

pnn44794 — Tue, 28 Aug 2018 03:06:31 GMT

Thank you, Anil, for your response. I believe you are correct and I'm looking into making a data model change. I'm still having a bit of a mental block though because I think I've been looking at this for too long.

What I didn't say above is that these different tables are from different sources and have different column names and I'm doing inline loads as well trying to compensate for that.

Right now, I'm manually entering values into variables and saving them. I will work on getting the data model corrected.