Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
QFanatic
Creator
Creator

Where not Exists - why is this working the way it does...

hi guys

PFA

In short - I have Dimension table with Aircraft ID's, that is not complete. What the code does, is read the Fact table as well, takes the ID's that are missing from the Dimension table, and concatenates it.

It works fine. LOL. I guess no one posts here if stuff works.

My question is - the solution contains a temp table. I'm thinking that it should work, without the temp table as well?

Can someone explain to me - why cant I do it without a temp table.

 

thanks

Labels (1)
1 Solution

Accepted Solutions
Kushal_Chawda

2 Replies
Kushal_Chawda

@QFanatic  see the attached

QFanatic
Creator
Creator
Author

Much simpler, thank you!