tag:blogger.com,1999:blog-5585680429157536914.post8679654639651797896..comments2023-12-19T01:06:46.450+00:00Comments on QlikView Addict: QlikView Functions: dual()Matt Fryerhttp://www.blogger.com/profile/16375702764551893303noreply@blogger.comBlogger14125tag:blogger.com,1999:blog-5585680429157536914.post-60400189024597820192015-03-25T21:47:45.338+00:002015-03-25T21:47:45.338+00:00Hi Cesar
That's a great question, and one tha...Hi Cesar<br /><br />That's a great question, and one that doesn't have a straightforward answer. It's a topic that could be the subject of an entire post in itself, but I'll try and keep the answer short here.<br /><br />One thing to keep in mind is that set analysis isn't like applying a where clause which is then tested against every record one by one. When you specify values in set analysis, you are essentially specifying a set of selections that should be made for the purpose of performing the calculation. Because it is simply making a selection, how fast that will be applied can be demonstrated by how quickly QlikView can apply a selection when you make one manually within a list box. <br /><br />As QlikView only stores distinct values within a field and what are effectively pointers between those values to indicate when they relate to values in other fields, whether you select a string or a number, it still has to follow the same number of pointers. And so any difference results solely in it's ability to test the desired value against the distinct list of values within that field once. <br /><br />Hopefully you can see that any difference would in most cases be so small that it's one of those things where I would personally go with the option that offered the best usability and only look at alternatives if I had an explicit performance issue. And if I did have a performance issue, there are a lot of other factors that would have a much more dramatic effect on it that whether I was specifying a string or a number in my set analysis.<br /><br />Regards<br />MattMatt Fryerhttps://www.blogger.com/profile/16375702764551893303noreply@blogger.comtag:blogger.com,1999:blog-5585680429157536914.post-91510637092785818402015-03-21T06:26:00.409+00:002015-03-21T06:26:00.409+00:00Are you able to attached a sample or link to a sam...Are you able to attached a sample or link to a sample?<br />Thank youAnonymoushttps://www.blogger.com/profile/06261683958160800773noreply@blogger.comtag:blogger.com,1999:blog-5585680429157536914.post-68961989218955008612015-03-19T12:40:44.328+00:002015-03-19T12:40:44.328+00:00Hi Matthew,
Thanks for the article. Very well exp...Hi Matthew,<br /><br />Thanks for the article. Very well explained!<br /><br />One question: I usually prefer to use numeric values on the set analysis expressions because I was told text is more costly to evaluate. Thinking about large applications, are there any performance draw backs for using text on the set analysis expressions when using dual fields?<br /><br />Regards,<br />CesarCesarhttps://www.blogger.com/profile/16606796323837573653noreply@blogger.comtag:blogger.com,1999:blog-5585680429157536914.post-16998161701903372152015-03-17T10:59:00.492+00:002015-03-17T10:59:00.492+00:00Hi Robert
It sound like you haven't created co...Hi Robert<br />It sound like you haven't created correct dual values as shown in the last but one example?<br /><br />Regards<br />MattMatt Fryerhttps://www.blogger.com/profile/16375702764551893303noreply@blogger.comtag:blogger.com,1999:blog-5585680429157536914.post-31253116425671016142015-03-17T06:18:06.947+00:002015-03-17T06:18:06.947+00:00Matthew,
I have been trying to replicate your last...Matthew,<br />I have been trying to replicate your last Example (CRM) but the count expression does not work for me.<br />When I change the Load and Won to 1 and 4 is working but not with the Text values.What the data behind the 'Opportunities' table?Anonymoushttps://www.blogger.com/profile/06261683958160800773noreply@blogger.comtag:blogger.com,1999:blog-5585680429157536914.post-38742986726048465892015-03-03T02:58:38.497+00:002015-03-03T02:58:38.497+00:00Thanks great article Thanks great article Anonymoushttps://www.blogger.com/profile/03485209460262589936noreply@blogger.comtag:blogger.com,1999:blog-5585680429157536914.post-2405819480727943002015-03-03T02:56:54.780+00:002015-03-03T02:56:54.780+00:00This comment has been removed by the author.Anonymoushttps://www.blogger.com/profile/03485209460262589936noreply@blogger.comtag:blogger.com,1999:blog-5585680429157536914.post-61965754498478161842014-09-26T11:39:13.614+01:002014-09-26T11:39:13.614+01:00Try looking at the subfield() function. It should ...Try looking at the subfield() function. It should do what you need. Something like subfield(NAME, '-', 1)<br /><br />Regards<br />MattMatt Fryerhttps://www.blogger.com/profile/16375702764551893303noreply@blogger.comtag:blogger.com,1999:blog-5585680429157536914.post-52670469265544481152014-09-23T18:42:11.892+01:002014-09-23T18:42:11.892+01:00i have a column\
------------
NONCORE- COLLECTION
...i have a column\<br />------------<br />NONCORE- COLLECTION<br />CORE-CODING<br />ABSET<br />BREAK<br />-----------------------<br />i used "Left(NAME,INDEX(NAME,'-')-1)AS CATAGORIES;"<br />then it wil come<br /><br />-------<br />CORE<br />NONCORE<br />------------<br />but not absent and break<br />how do i get absent and break<br />shiranthajavahttps://www.blogger.com/profile/12632558099661756314noreply@blogger.comtag:blogger.com,1999:blog-5585680429157536914.post-26471604104183052722013-11-27T19:44:34.243+00:002013-11-27T19:44:34.243+00:00excellent article. crisp and clear, thanks.excellent article. crisp and clear, thanks.Vinoth Selvamhttps://www.blogger.com/profile/15953608230800839169noreply@blogger.comtag:blogger.com,1999:blog-5585680429157536914.post-14570381916420803122013-11-20T09:39:23.408+00:002013-11-20T09:39:23.408+00:00Great post with some nice examples. Great post with some nice examples. Anonymoushttps://www.blogger.com/profile/09116155429941337862noreply@blogger.comtag:blogger.com,1999:blog-5585680429157536914.post-41374243697427015932013-10-10T03:55:00.181+01:002013-10-10T03:55:00.181+01:00Very deeply explained.. i was not aware of this ma...Very deeply explained.. i was not aware of this magical behavior of dual function..<br />Thanks for such a nice article Anonymoushttps://www.blogger.com/profile/11459804486602887900noreply@blogger.comtag:blogger.com,1999:blog-5585680429157536914.post-34111025192688147132013-04-28T14:56:43.545+01:002013-04-28T14:56:43.545+01:00Excellent article, thank you.Excellent article, thank you.Anonymoushttps://www.blogger.com/profile/02147012746338465023noreply@blogger.comtag:blogger.com,1999:blog-5585680429157536914.post-73105622147633490622012-12-14T22:16:48.131+00:002012-12-14T22:16:48.131+00:00awesome. Thanks for the tips and well written exam...awesome. Thanks for the tips and well written examples. Really helps to see it spelled out like this.McNaterhttps://www.blogger.com/profile/05212493897431023273noreply@blogger.com