Tagged with max - Visokio Forums http://forums.visokio.com/discussions/tagged/max/feed.rss Mon, 30 Oct 17 18:15:57 -0400 Tagged with max - Visokio Forums en-CA Merge: Assigning data into bands? http://forums.visokio.com/discussion/2902/merge-assigning-data-into-bandss Tue, 07 Apr 2015 12:24:51 -0400 DarrenElding 2902@/discussions
I have a shipment file with a list of shipments of different weights. I have a second data table with a list of weights alongside the weight band descriptions, e.g. 0kg = 0-5kg, 5kg = 5-10kg, 10kg = 10-30kg, etc. I want to merge the weight band description field into the shipment file so that, for example, a 25kg shipment is assigned to the 10-30kg weight band. The problem is that in the merge function if I select the shipment weight to be 'greater or equal to' the weight in the weight band file I get a many to many error as a 25kg shipment is greater than 10 so falls into the 10-30kg band but is also greater than 5kg so also falls into the 5-10kg band.

Is there a way I can get it to assign only the 'highest' weight band in which the shipment falls and not every weight band below that as well?

Many thanks

Darren]]> Help with Subset Function http://forums.visokio.com/discussion/1386/help-with-subset-function Tue, 13 Mar 2012 02:28:01 -0400 vijay_chidambaram 1386@/discussions
I am facing a little trouble in implementing Subsets and Filters in this particular situation.
image
In the above (or attached) screenshot, when I select Quarter 4 from the side filter, Omniscope subsets all the data under Quarter 4 and applies it to all the above four views. But in the first view, which is a content view (marked with red star), I need to show the results of current quarter, previous quarter and have to calculate the difference in percentage between the two quarters. I tried various different methods to implement it but nothing worked for me. Could you please suggest me a solution to implement this. I have also sent the IOK file to support@visokio.com.

Thanks

Kind Regards
Vijay]]> VARCHAR(MAX) columns not supported? http://forums.visokio.com/discussion/764/varcharmax-columns-not-supporteds Fri, 13 May 2011 08:31:15 -0400 starsky51 764@/discussions Is this a limitation with the jtds driver or with Omniscope itself?
We are currently using Build 2.6-alpha b557 (13-Mar-2011 22:52:03).]]>