Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikers,
As we do in SQL:
Select <f1>, <f2> from abc where <f1> IN (Select <f1> from def)
Can we do a similar execution using the LOAD in Qlikview.
LOAD <f1>, <f2> resident abc where <f1> IN (LOAD <f1> resident def)
Did not research a lot. Thought first I will ask you guys.
Rocky,
unfortunately, "IN" functionality is not implemented in QlikView. You can use somewhat similar exists(), only keep in mind that the comparizon is performed at the field level, as opposed to a table level. If you have to ensure that you are comparing to existing values of a field in a specific table, make the field unique to tha table (in other words, if you compare to a key field, create another copy of the same field just in the desired table, and compare to the copied field instead.
I use match instead
match( s, expr1 [ , expr2, ...exprN ] )
Compares the string s to a list of strings or string expressions. The
result of the comparison is an integer indicating which of the comparison
strings/expressions matched. If no match is found, 0 is
returned. The match function performs a case sensitive comparison.
Examples:
match( M , 'Jan' , 'Feb' , 'Mar' )
where M is 'Feb' returns 2
match( M , 'Jan' , 'Feb' , 'Mar' )
where M is 'Apr' or 'jan' returns 0
I would do the same thing if it were a limited standard set of values to compare with.
But that is all the data for a given date.
So, I would assume this not to be solution for it.