tag:blogger.com,1999:blog-5585680429157536914.post7392843513868022004..comments2023-12-19T01:06:46.450+00:00Comments on QlikView Addict: Explaining JoinsMatt Fryerhttp://www.blogger.com/profile/16375702764551893303noreply@blogger.comBlogger14125tag:blogger.com,1999:blog-5585680429157536914.post-37216350849243668032016-12-01T16:12:53.545+00:002016-12-01T16:12:53.545+00:00Hi Matthew, thanks for the post.
I don't know...Hi Matthew, thanks for the post. <br />I don't know why I cannot make it ! :(<br />I have to files with column ID in common. But does not show the fields in common in same row... it creates two row for each ID. Could you please help? Thanks!meR_https://www.blogger.com/profile/18432861206589338962noreply@blogger.comtag:blogger.com,1999:blog-5585680429157536914.post-10600475424278369172015-08-06T12:15:13.198+01:002015-08-06T12:15:13.198+01:00Hello Can you please help me with join condition:
...Hello Can you please help me with join condition:<br /><br />I have 2 qvds: <br />QVD1 ..(15 ml. rows, 180 columns):<br />A 1 2 3 4 5<br />B 1234<br /><br />QVD2 (14 ml. rows and 190 columns)<br /><br />A 1234<br />B 2345<br />.<br />.<br />Z<br />Name of columns are same.<br /><br />Looking to create a QVD3 ( as a result of Inner Join of QVD 1+2)<br /><br />Will this work? OR can you suggest optimum way to do this?<br /><br />QVD3:<br />aaa:<br />Load *<br />from QVD1.qvd<br /><br />Inner join (aaa)<br /><br />Load * from QVD2<br />Where field a='x' and b='y';<br /><br />let vdate=peek(date);<br />store aaa into QVD3_$(vdate);<br /><br />Deep chatterjeehttps://www.blogger.com/profile/08055366757326189438noreply@blogger.comtag:blogger.com,1999:blog-5585680429157536914.post-46731185067886581212015-02-09T07:52:29.624+00:002015-02-09T07:52:29.624+00:00Hello, I watched many videos and read many documen...Hello, I watched many videos and read many documents about integrating between Google map and QlikView but I still failed to integrate between them. I want to add the country of Kuwait to my QlikView, could anyone help me from A to Z on how to integrate between QlikView and Google map and I would be thankful if it was a youtube tutorial.Anonymoushttps://www.blogger.com/profile/06531553245793740593noreply@blogger.comtag:blogger.com,1999:blog-5585680429157536914.post-43010009269733744632014-06-19T15:05:08.466+01:002014-06-19T15:05:08.466+01:00Thank u
What is the defalut join in qlikview?
Plea...Thank u<br />What is the defalut join in qlikview?<br />Please tell meAnonymoushttps://www.blogger.com/profile/09347244484059191320noreply@blogger.comtag:blogger.com,1999:blog-5585680429157536914.post-38343155147920849842012-09-27T23:40:22.418+01:002012-09-27T23:40:22.418+01:00Hi
Your method of concatenating the strings will ...Hi<br /><br />Your method of concatenating the strings will work but there is another solution which indicates why your original wasn't working:<br /><br />SET a = 'aaa';<br />LET b = a & 'bbb';<br /><br />You will notice there are 2 differences in the second line. Firstly, you will notice the command SET has been replaced with LET. If you read this post you'll see the difference between the two http://www.qlikviewaddict.com/2012/02/set-vs-let.html<br /><br />The second difference is that once we use LET, we not longer need to use $() to expand the contents of the variable "a" and can simple use the variable name instead.<br /><br />Hope this helps!<br />MattMatt Fryerhttps://www.blogger.com/profile/16375702764551893303noreply@blogger.comtag:blogger.com,1999:blog-5585680429157536914.post-79054209397804395432012-09-27T15:39:04.228+01:002012-09-27T15:39:04.228+01:00Finally I obtain the solution guys! I answer mysel...Finally I obtain the solution guys! I answer myself: <br /><br />------[my example code]-----------------------------------<br />//two vars declared ('b' is 'a' and string concat)<br />set a = "aaaaa";<br />set b = $(a)bbbb;<br /><br />//this creates a MessageBox with message 'b', title 'msgbox', //one OK button, with icon asterisk message and put the focus //in the first button defined. <br />//<br />//The following code: 'as x, 2 as r Autogenerate 1;' I do not //understand but if you do not put this we will have an error //executing script<br /><br />Load<br />MsgBox('$(b)', 'msgbox', 'OK', 'ICONASTERISK', 'DEFBUTTON1') as x, 2 as r<br />AutoGenerate 1;<br />----------------------------------------------------------<br /><br />We define two variables like String. 'b' is a new String concatenated with 'a'. The concatenation is direct without using any special modificator like another languages as typical '.', '+' or '&'.<br /><br />For use one variable and expand it inside String, we put directly inside String declarated, between ''. <br /><br />Enjoy! Yago L.R.https://www.blogger.com/profile/07362788270212059145noreply@blogger.comtag:blogger.com,1999:blog-5585680429157536914.post-8770330290293503012012-09-27T14:51:41.857+01:002012-09-27T14:51:41.857+01:00I am newbie in Qlikview Scripting. About concatena...I am newbie in Qlikview Scripting. About concatenating vars... I stay all afternoon trying resolve this issue. <br /><br />Problem: How to concat a variable with a string? It is basic and stupid but I am testing all possible formats but it is impossible.<br /><br />example: <br /><br />set a = "aaaaa";<br />set b = $(a) & "bbbb";<br /><br />The target is to use b like a string composed by more variables. Yago L.R.https://www.blogger.com/profile/07362788270212059145noreply@blogger.comtag:blogger.com,1999:blog-5585680429157536914.post-19174009321824959782012-09-01T20:53:16.622+01:002012-09-01T20:53:16.622+01:00Hi, Glad it help!Hi, Glad it help!Matt Fryerhttps://www.blogger.com/profile/16375702764551893303noreply@blogger.comtag:blogger.com,1999:blog-5585680429157536914.post-50345926486707329312012-08-31T16:50:28.435+01:002012-08-31T16:50:28.435+01:00Hi Matthew,
thank you very much it helps me a lot ...Hi Matthew,<br />thank you very much it helps me a lot on clearing my doubts.<br />Unknownhttps://www.blogger.com/profile/02295666206450459258noreply@blogger.comtag:blogger.com,1999:blog-5585680429157536914.post-33717227048766198182012-07-18T00:13:39.760+01:002012-07-18T00:13:39.760+01:00Matthew,
I got some clues from Qlikview Community...Matthew,<br /><br />I got some clues from Qlikview Community, to my problem, but it still don't answer my question... but I think that help to explain what I wanted to say... <br /><br />The clue, was to use Mapping to Map a null value and the value I want... like the example code...<br /><br />// Map null into another value<br />Map_Null1:<br />MAPPING LOAD<br /> Null(),<br /> -2<br />Autogenerate 1;<br /> <br />Map_Null2:<br />MAPPING LOAD<br /> Null(),<br /> 'NotApply'<br />Autogenerate 1;<br /> <br />//now decide what map to use where<br />MAP id_subchoice USING Map_Null1;<br />MAP detail USING Map_Null2;<br /> <br />//now load your data<br />choices:<br />LOAD * <br />inline [ id_choice , name , formatted<br /> 1 , 'choice1' , 'Choice 1.'<br /> 2 , 'choice2' , 'Choice 2.'<br /> 3 , 'choice3' , 'Choice 3.' ]<br />; <br />outer join (choices)<br />LOAD *<br />inline [ id_subchoice , id_choice , detail <br /> 1 , 1 , 'choice1_A' <br /> 2 , 1 , 'choice1_B' ];<br /> <br />//Now force the reload to apply the null mapping<br />LOAD id_choice,<br /> id_subchoice,<br /> name,<br /> formatted,<br /> detail<br /> RESIDENT choices; <br /><br /><br />This code do near what I need... the unique problem, is that the results for the OUTER JOIN are duplicated... and the duplicated are showed without the transformation.... :/<br /><br /><br />With this example, do you think in any possibility to make the code work?<br /><br />Thanks,<br />Carlos FigueiredoAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5585680429157536914.post-18559032256139995622012-07-17T12:14:05.257+01:002012-07-17T12:14:05.257+01:00Hi Carlos
I'm not sure exactly what you mean ...Hi Carlos<br /><br />I'm not sure exactly what you mean but QlikView won't connect records with a null entry in the key field. <br /><br />You can transform a null into anything by modifying the load statement like this:<br />if(isnull(MyField), -1,0) AS MyField<br /><br />You can read more on working with nulls in QlikView here http://www.qlikviewaddict.com/2012/04/handling-nulls-in-qlikview.html<br /><br />Regards<br />MattMatt Fryerhttps://www.blogger.com/profile/16375702764551893303noreply@blogger.comtag:blogger.com,1999:blog-5585680429157536914.post-27230916307669102792012-07-17T01:23:44.584+01:002012-07-17T01:23:44.584+01:00Hey Matthew,
Thanks for the tips... but I have a ...Hey Matthew,<br /><br />Thanks for the tips... but I have a question about a necessary treatment of the nullable fields, when some data is not present in one of the tables present in an OUTER JOIN...<br /><br />specifically is: <br />I need to transform the null (empty) value into -1... how can I do it?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5585680429157536914.post-66031737712725862622012-06-14T15:35:32.896+01:002012-06-14T15:35:32.896+01:00Hi Erik
I'm glad it helps. Yep you are right,...Hi Erik<br /><br />I'm glad it helps. Yep you are right, I've corrected it above now.<br /><br /><br />Regards<br />MattMatt Fryerhttps://www.blogger.com/profile/16375702764551893303noreply@blogger.comtag:blogger.com,1999:blog-5585680429157536914.post-31749025085121967692012-06-14T15:23:04.570+01:002012-06-14T15:23:04.570+01:00Dear Matthew,
thanks for the examples, they reall...Dear Matthew,<br /><br />thanks for the examples, they really cleared my mind.<br />one remark: the table resulting from the OUTER JOIN shouldn't rather be<br /><br />A 1 (empty)<br />B 2 X<br />C 3 Y<br />(empty) 4 Z<br /><br />You wrote<br />A 2 (empty) and<br />(empty) 2 Z<br /><br />Many thanks<br />Erikerikhttps://www.blogger.com/profile/06499905267765571178noreply@blogger.com