topic Re: Create new 'measure' in load script between two tables in App Development

Create new 'measure' in load script between two tables

drew61199 — Thu, 10 Feb 2022 04:25:10 GMT

I have two tables with time values and need to calculate the variance between the two times (OPEN_TIME and OPEN). I'm able to combine the two tables into a singular table (DATA) as I believe this is necessary. I'm not sure how to proceed from here though. As you can see in my snip I originally tried inserting it in the last LOAD, but I assume b/c the table isn't "finalized", OPEN_TIME isn't found as it's still technically in DATA and the two tables are not fully joined at this point in time?!?

So I then tried adding another load to add the calculation and although it doesn't fail, the dimension VARIANCE does not populate in my dashboard.

FYI - I am able to calculate VARIANCE utilizing the formula within the dashboard, but I also need to COUNT the facilities over a certain threshold in minutes and that is not working out for me. So my new plan is create VARIANCE and another dimension (YES / NO based on IF statement) so that I can more easily count that within the dashboard. I'm open to other ideas though from the QLIK pros! Thanks in advance

Re: Create new 'measure' in load script between two tables

chris_djih — Mon, 14 Feb 2022 15:01:58 GMT

On your last join you have to pass a key-field to tell qlik on which field it should join the tables.
at the moment you just telling qlik: Join this new field.
Unfortunately Qlik is not asking or showing an error, that qlik does not know how to join this new field.
Seems as if "UFN" is your keyfield, so your last join would be

Left Join(Data) Load UFN, Interval( ... - ..) as VARIANCE resident DATA;

Re: Create new 'measure' in load script between two tables

drew61199 — Mon, 14 Feb 2022 16:54:31 GMT

Worked perfectly. Thank you!