Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Classic Search
Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
- Qlik Community
- :
- All Forums
- :
- Search
Search
Search the Community
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
9,368 results
Sorted by:
2015-09-17
12:13 PM
1 Like
...lready existed I tried adding a WHERE clause WHERE EXISTS (Records). This got an error "wrong syntax near Records". Did a little more digging, saw that I apparently need the field name from both the exist...
- Tags:
- qlikview_scripting
Labels
- Subscribe by Topic:
-
QlikView App Dev
Show results in replies (5)
-
You don't need the Where exists. The Left Join will do exactly that. But if you would use the Exists...
-
...ecords, REF WHERE EXISTS (RECID, Records); SQL Select RECID AS Records, REF F...
-
...yntax for EXISTS in the WHERE clause? If I'm joining two tables where the field is called "Key1" in t...
-
Sunny already replied back to the original question, if you want to use a where exists, you first h...
-
...ing QVD for any record that ALREADY exists in my QVD. I will try your suggested syntax this a...
2017-07-14
01:30 PM
...WF';
and this works, but when I change "where test_SYSTEM_CD <> 'CWF';" to "where not exists(test_SYSTEM_CD,'CWF');" it returns 0 results. this would probably only save me a few seconds, but i am m...
- Tags:
- qlikview_deployment
Labels
- Subscribe by Topic:
-
QlikView Administration
Show results in replies (4)
-
...est_ACTIVITY_TS, test_ACTIVITY_TYP_CD, test_SYSTEM_CD From YourQVD (qvd) where not exists(t...
-
...ourQVD (qvd) where not exists(test_SYSTEM_CD,'CWF');
-
...est_ACTIVITY_TS, test_ACTIVITY_TYP_CD, test_SYSTEM_CD From YourQVD (qvd) where not exists(test_SYSTEM_CD,'CWF');
-
If that is true, then why does Qlikview help say this: "exists(Month, 'Jan') returns -1 (true) i...
2011-06-07
01:12 PM
...ow my task is to find how many of those products are missing. I guess we need to use WHERE Exists, can someone suggest me what should I do next. Thanks and Regards, Bikash
Labels
- Subscribe by Topic:
-
QlikView App Dev
Show results in replies (9)
-
...bsp; * FROM History.qvd (qvd) WHERE NOT EXISTS (ProductID); DROP TABLE T...
-
...OAD * WHERE EXISTS(AB); LOAD A & '-' & B AS AB, D, E from TABLE2; I made this ... h...
-
Okay Steve I am working on it. I will post that once I can achieve it. You have a nice time, Re...
-
Surely if both Present and History have loaded into a single table, and the only common key between...
-
...he above then I can perform the Where Exists clause that you suggested. Thanks again, Bikash
-
If you load exactly the same columns from both QVD's they will automatically concatenate. It ...
-
Steve can you tell me how to write the code to concatenate. Because both the identical QVDs has e...
-
...he WHERE EXISTS syntax from above, but replace ProductID with [Part ID] it shold only load the rows w...
-
Hi Steve, Thank you so much for the answer. Could you please tell how does it find the missing ...
2017-08-21
05:12 PM
I'm trying to pull information from one table, while excluding anyone who exists in another table, then using it in a filter pane. For example.... Pull all entities in table A who have never b...
Labels
- Subscribe by Topic:
-
QlikView App Dev
2013-04-17
04:44 AM
2 Likes
...OAD * INLINE [ F3, F4 A, AA B, BB C, CC E, EE ]; Now I want to know how to use Where not exists...
- Tags:
- qlikview_scripting
Labels
- Subscribe by Topic:
-
QlikView App Dev
2012-11-29
12:26 PM
This could be unintelligent question still I need to do. I have two table like A and B Here A is QVD and B Is direct connected Db and trying use where exists like below A: L...
Labels
- Subscribe by Topic:
-
QlikView App Dev
2010-01-18
10:35 AM
...se the following stmt : SQL Select * FROM VBAK WHERE exists([%SalesOrderDocument_Key], [ZORDER]); Thanks Thom [ZTRPST]: // Time Reports - Spread Time Posted Load [ZORDER] & '/' & [Z...
- Tags:
- where
- where_exists__
Labels
- Subscribe by Topic:
-
QlikView App Dev
Show results in replies (9)
-
...oad the next table VBAK with [VBELN] field and with this Load statement ,use Where exists([Z...
-
Silky, Thanks. What I needed to do was create temp tables and do the where exists against them. Thom
-
Yes. I am trying to extract sales orders from SAP. In VBAK we have 16 million rows and on VBAP we h...
-
Hi Thom Are you trying to extract from SAP ? If so how many records do you have in the ODS's you a...
-
...OAD statement, not the in SQL statement. LOAD ... WHERE EXISTS(the field you loaded previously, t...
-
...eversed? Thanks SQL Select * FROM VBAK WHERE exists([%SalesOrderDocument_Key], [Order Number_ZORDER]);
-
You renamed it: [ZORDER] as [Order Number_ZORDER], Rainer
-
ZORDER is in the first table ZTRPST
-
Hi, so far I see you did not have a field ZORDER. Rainer
2012-05-14
10:06 PM
1 Like
...) you get the point So my plan was to move that nested select statement to it's own LOAD, and then in another LOAD bring in the core data, but place a WHERE NOT EXISTS (uidcot). E...
Labels
- Subscribe by Topic:
-
QlikView App Dev
2017-09-12
08:05 AM
load * inline [ Region,Sales A,10 B,20 C,30 D,40 ]; Now here I want to load only Region 'C' data using only Where Exists function.Please help me in doing that. I am also trying like this....
Labels
- Subscribe by Topic:
-
QlikView App Dev
Show results in replies (4)
-
...ales A,10 B,20 C,30 D,40 ] Where Exists(Region);
-
Find the attached for the sample example for the explain of the Where Exists //In this inline t...
-
...nline [ Region,Sales A,10 B,20 C,30 D,40 ] Where Exists(RegionToload,Region);
-
Where Exists() will filter an ongoing load by analysing a specific column in the current row and c...
2021-03-22
11:48 AM
...DATE>= '22.03.2021'; Concatenate LOAD ID, TEXT, DATE FROM [FULL.qvd] (qvd) WHERE NOT EXISTS(ID); STORE [DELTA&FULL] into [FULL.qvd] (qvd); So QV displays only t...
Labels
- Subscribe by Topic:
-
QlikView App Dev