Feed aggregator

The Squirro Team is Growing

Squirro Blog - July 22, 2014 - 01:00
The last two months have seen the Squirro team grow dramatically with new team members and a whole...

LivingQlikView Enhances Visual Data Group's Technical Support

VDG blog - July 21, 2014 - 07:09

Visual Data Group has always prided ourselves with maintaining a highly skilled technical team.  A great example is our senior member, Aaron Couron.

Aaron has been a major contributor to our organization providing development, training and support services for our clients since 2010.  He has been a large part of Visual Data Group’s success.


read more

Categories: Latest VDG News

Sensory Data

QlikView Blog - July 21, 2014 - 04:36

Why do people still go shopping rather than using the internet all the time? After all, the internet is normally quicker and your local shopping centre can never hope to have as many brands as you can find using your PC or tablet. It’s partially a social thing - we like to meet up with friends have something to eat and a chat. While we are shopping it’s a tactile thing - holding the item (or even smelling it!) as this reinforces the fact that it is real and of good quality. Retailers know this and try to lure us in with bright signage and interesting aromas. Once we have purchased our items we sit down with our friends over a drink and compare our purchases hoping for compliments or praise.

Ladies.jpg(Getty images)


When we are shopping on the internet we have none of this sensory feedback, apart from maybe a few flashing banners. We have to trust what the retailer has told us about the item and trust that what they say is true even down to the dimensions. This is difficult, and why some people will go to the shop see the product and then buy it on the internet.

If we are like this when shopping for clothes then consider how people  behave when looking at millions of pounds, euros or dollars of sales figures and inventory items.  Just like when internet shopping, we are compelled to trust the numbers and words we see on the screen even though there is much more at stake, the money is not in a safe somewhere or the inventory may be 1000’s of miles away. This is even more important when we talk of fully optimized supply chains where stock is kept to the bare minimum.



(Getty images)

We solve this problem of trust by working in groups and comparing against known facts we’ve encountered before. How were the sales of this product last year? What are the sales of comparable products? We then show these figures to our peers and ask for comment, slowly turning over the figures in our head.

So replace the attractive signs with compelling visualisations, the aroma with data scent (bit of a stretch I know) and the chat with friends with real time collaboration.You then have a business discovery tool such as QlikView, which helps people feel, test and believe the data they’re seeing.

None of this is new.  It’s just taken a while for software providers to catch up with the human brain!

2014-07-21T11:36:00Z 1 day 19 hours ago 0 http://community.qlik.com/blogs/theqlikviewblog/comment/sensory-data http://community.qlik.com/blogs/theqlikviewblog/feeds/comments?blogPost=3860 http://community.qlik.com/blogs/theqlikviewblog/2014/07/21/sensory-data

Looping Through Files / Living QlikView

VDG blog - July 18, 2014 - 10:01

      Can’t you just pull all the logs into QlikView?  

There are times when we might want to pull several files into QlikView.  Some typical examples: Read more!


Categories: Latest VDG News

Nominated for the Swiss ICT Oscar!

Squirro Blog - July 17, 2014 - 14:49
Squirro got nominated for the Swiss ICT Oscar! We are looking forward to the prize ceremony on...

Leveraging ETL systems and your investment with Squirro

Squirro Blog - July 15, 2014 - 05:58
ETL systems are commonly used to integrate data from multiple applications, typically developed and...

Squirro are pleased to announce a partnership with Advanced Analytic Services to grow presence in China and Southeast Asia

Squirro Blog - July 14, 2014 - 02:28
CHINA, July 13, 2014 – Squirro, the leader in Context Intelligence, and Advanced Analytics Services,...

Registration Opens for Qlik Conference 2014

QlikView press releases - July 8, 2014 - 15:00
Qlik, (NASDAQ: QLIK), a leader in user-driven Business Intelligence (BI), today announced that registration is open for its inaugural Qlik Conference 2014 (http://go.qlik.com/qlikconference2014), which will bring together Qlik customers, partners and experts to help users better capitalize on data to transform their organizations.
Categories: Latest News

Regain control over your inbox with Squirro for Exchange!

Squirro Blog - July 8, 2014 - 08:33
                Is your inbox just another data source or are you using the dominant...

Get all the Data on the World Cup

Squirro Blog - July 4, 2014 - 06:33
Together with our partner Cellent we developed a World Cup Dashboard. You get all the match...

Top 5 Little Known QlikView Shortcuts

Aaron Couron » Living QlikView - July 1, 2014 - 03:00

In this post, I wanted to highlight a few little-known QlikView keyboard shortcuts.  Everybody is familiar with Ctrl-E to edit script or Ctrl-R to reload our application.  But lets take a look at a few shortcuts that you might not know about that provide some quick and cool functionality.  We will do this in reverse order for dramatic effect ;)

5.  Move locked objects: Alt-Drag
If you ever lock down your objects (Properties --> Layout --> Uncheck Allow Move/Size) then you know that you have locked their movement even for you, the developer.  Instead of checking this option again for all your objects, you can simply hold down Alt and drag your object wherever it is needed. 

4.  Comment & Uncomment: Ctrl-K-C / Ctrl-K-U
I am a fan of comments both in the script and in front end expressions.  These comments can help the next developer figure out why you did something, or far more likely, remind YOURSELF of what YOU did 3 weeks ago in this application.  Most people are familiar with highlighting text, right clicking and selecting comment or uncomment.  But the keyboard shortcut Ctrl-K-C will comment highlighted lines and Ctrl-K-U will uncomment the selection. 

3.  Activate previous or next sheet: F6 / F7
If you are progressing sequentially through the sheets of an application, F7 will save you a click as you proceed rightward from one sheet to the next.  F6 will move you backwards or right to left.

2.  Object properties:  Alt-Enter
Probably one of the most frequent operations is right clicking on an object and selecting properties.  There's a shortcut for that.  You still must activate the object with a click, but then Alt-Enter will get you to the properties.  That's a time-saver for sure.  If no object is selected it will invoke the sheet properties similar to if you right click in open space and select properties.

1.  Generate sample data: Ctrl-Q (2x)
Maybe not as usable as the previous, but this one takes the top spot for sheer cool factor.  Go to the script editor, and tap Ctrl-Q twice.  This will generate some scripting that, when reloaded, will create three tables of associated sample data for you to test with.  The script requires no outside files to run and will generate about 2,000 rows of transactions for you with a couple associated dimension tables. 

Please feel free to gloat if you knew these already.  Or I would be happy to hear about any other really cool shortcuts you have uncovered in your trials. 

Categories: Latest VDG News

Squirro and Sovereign Merchant welcome partnership with UXC Professional Solutions

Squirro Blog - June 30, 2014 - 01:58
Australia June 26, 2014 – Squirro, the leader in Context Intelligence, and UXC Professional...

Thangamayil Jewellery Strikes Gold with Qlik, Saves 55 Percent on Operating Costs

QlikView press releases - June 29, 2014 - 15:00
Qlik (NASDAQ: QLIK), a leader in user-driven Business Intelligence (BI), today announced that Thangamayil Jewellery (Thangamayil), a leading retail chain in India with 30 stores across several districts of Tamil Nadu, is using the QlikView Business Discovery platform.
Categories: Latest News

Everything in its Place

Aaron Couron » Living QlikView - June 24, 2014 - 03:00
The Problem
“Is there an easy way to fully expand and fully collapse my pivot chart?” or its cousin,“Can I just press a button to get the pivot chart back to a default?”These are relatively frequent questions that I never had fully satisfactory answers for.Before we get into the tip, I used to recommend Right Click àCollapse All or Right Click àCollapse Dimension Columns to collapse the chart and Right Click à Expand All to expand columns (one-by-one).
That solution is not great because first, if you are expanding the chart all the way out, you still have to do it one column at a time.  But the biggest problem presents once you pivot a dimension horizontally.  At that point, you cannot collapse the pivoted column without first un-pivoting the column.
Solution – The Layout Bookmark
The solution to this is actually pretty neat.  It involves a special kind of bookmark – The Layout Bookmark.  Our example will simply involve a collapsed state and a fully expanded and pivoted year column state.
First create a pivot chart and manipulate the columns so that none are pivoted and all are collapsed. 
Then we simply create a document bookmark Bookmarks àAdd Bookmarks as follows.
Notice that we have unchecked “Include Selections in Bookmark”.  We want to be able to invoke this bookmark without affecting the current selections.  The only thing this bookmark will change will be the “layout state” of the application.Next, expand out all the columns and then pivot the year column horizontally. 
    Create another layout bookmark.  Now we need to create a couple buttons that will simply invoke each of these layout bookmarks.  But first, we need to know the id’s.  Go to Bookmarks àMore…
 There you can see that the id’s for these bookmarks are BM01 and BM02.  Take note of them.Finally, create the buttons.  You can name the button whatever you want and then for the button action, use Bookmark àApply Bookmark along with the id for the bookmark you with to trigger. Here is the finished product.  Hitting the buttons will expand or collapse the chart to the desired setting.
NotesThere are some complications to be aware of when creating layout bookmarks.·         The layout state affects the entire sheet.  When you create a layout bookmark, it is taking a snapshot of the entire sheet layout, not just the pivot chart you are concerned with.  This includes minimize/restored settings and cyclic dimensions for all objects within the sheet.
·         The layout state activates the sheet.  This means that if you put this button on a different sheet, it will activate the sheet the bookmark was created on.  This could be good or bad but is important to understand for your use-case.
·         Layout states are hidden in containers.  If your charts are in a container, the layout state for objects within the container will not be saved.
ConclusionSome of the other things that might be done using layout bookmarks.·         Default sheet state·         Set a cyclic dimension to be shown·         Set a grouped expression to be shown·         Set restored or minimized objects on a sheet·         Set which object is shown within a single style containerI would love to hear any other ideas you have for this concept or other feedback.  Happy Qliking.
Categories: Latest VDG News

Easy Way to Collect QVD Stats

Aaron Couron » Living QlikView - June 18, 2014 - 03:00
 Collecting Stats Helps Debugging and Alerts You to ProblemsMost organizations will use QVD Generators to build out QVD data layers suitable for QlikView’s consumption.  There is generally no need to create any visualizations in these QVD Generators except for maybe some validation tables and some QVD statistics.  Today we will focus on an easy way to gather those statistics.  The statistics I generally gather help me answer questions regarding the output QVDs. ·         Which QVDs were written with this application?·         How long did it take to create this QVD?·         How many rows were written?·         How many fields were in each table?Obviously, being able to easily answer these questions helps us better understand and serve the BI enterprise.  It also provides a helpful tool for debugging logical errors in our QlikView scripts.And because we actually take this statistics table and write it to QVD as well, we can use it in later loads as needed to create a data source lineage for a particular application.  Another benefit of creating this statistics QVD(s) is that I can drop all the tables that created the QVDs while still retaining the statistics.  This leaves the application light and quick to save.Here is an example of the front end to show you what kind of data will be collected and displayed.  Of course, the stats you collect and present are really up to you, the developer.  How to set up the collectionI use blocks of code that can be basically put into any script and adjusted as needed.  We basically have four chunks of code that get deposited into our script. 1.       Set up any needed global variables and set up the statistics table structure.2.       Set up a sub-routine that creates the stat table.3.       Change the start time and table name each time we go to a new QVD.4.       Call the subroutine. Set up any needed global variables and set up the statistics table structureFirst, create any variables that will need to be collected in your statistics or displayed in your front end.  For this example, we are using a variable to determine my directory, the name of my environment, the source, division and the path for my statistics QVD.  These two chunks of script should be inserted towards the beginning of the script before any loading occurs.//dev
set vDir = 'C:\Users\Aaron\Documents\QlikView Apps\Blog Apps\Statistics Collection';
set vEnv = 'Dev';
//set vDir = 'D:\QlikView Documents\Production\Sales';

//   Set variables for qvd naming
set vDivision=  'QAP';
set vSource =   'BAAN';

LET StatisticsPath = '$(vDir)\ETL_Statistics_$(vDivision)_$(vSource).qvd'; We also will look for an existing statistics QVD and if one is not found, we will create it.IF FileSize('$(StatisticsPath)') > 0 THEN //  The Statistics QVD already exists.
ELSE // The Statistics QVD needs to be created

    TableName, Division, Source, ReloadedDate, StartTime, EndTime, Duration, Records, Fields
    , ];

STORE Statistics INTO $(StatisticsPath)(qvd);
DROP TABLE Statistics;
END IF    Set up a sub-routine that creates the stat tableNext we create a subroutine that appends the statistics each time we load new data into a QVD.  This script records all of the needed data from whatever load has just occurred, adds it to the existing statistics records and then saves the whole thing back to QVD.  This script gets inserted just below the prior set up stuff and will be called at various times later in the script.sub Stats

     //   Call this script between qvd store and drop table commands to gather statistics for the qvd. 
     //   There must be a vStartTime and a vTable variable
     LET vEndTime = NOW();
     LET vRecords = NoOfRows('$(vTable)');
     LET vFields  = NoOfFields('$(vTable)');
     LOAD * FROM $(StatisticsPath)(qvd)   WHERE TableName <> '$(vTable)';
     JOIN (Statistics)
     LOAD DISTINCT '$(vTable)' AS TableName, '$(vDivision)' AS Division, '$(vSource)' as Source, DATE(NOW()) AS ReloadedDate, '$(vStartTime)' AS StartTime, '$(vEndTime)' AS EndTime,
           INTERVAL(NUM('$(vEndTime)') - NUM('$(vStartTime)'),'hh:mm:ss') AS Duration, $(vRecords) AS Records, $(vFields) as Fields
     RESIDENT Statistics;
     STORE Statistics INTO $(StatisticsPath)(qvd);
     DROP TABLE Statistics;

end sub   Change the start time and table name each time we go to a new QVDSo now we go about the business of loading data from our data sources and creating QVDs.  The basic idea is that we will need to establish some variables at the beginning of each load and then run the subroutine at the end of each load.  Using this approach we can collect statistics for every QVD that gets created.  Start by adding this script to the top of each data loading section.  Note the vTable variable could also be used within your load statements to name your table.//   Append this script to the start of each qvd creation.
LET vStartTime = NOW();
SET vTable = 'ETL_Sales_Header';   Call the subroutineFinally, we can call the statistics subroutine that will record our ending variables and append the QVD.  This simple code will run the routine we created in the second step.//   call subroutine to gather statistics for the qvd.
call Stats; Place this code after we store each data QVD.  One thing to note is that you should wait to drop the data QVD until after this subroutine runs or simply drop them all at the end of your script. Thoughts?There are many ways we can simplify the data we are collecting or expand the data.  Hopefully this structure is clear and economical enough for you to adjust to your needs.  The example I provided is simply what I use to complete this task and I tweak the code depending on the situation.As always, I hope you find this valuable.  Please let me know what you think.  And if you accomplish statistics collection differently or can improve upon this, please participate in the discussion.
Categories: Latest VDG News

Qlik and Cloudera Host Big Data Virtual Event

QlikView press releases - June 17, 2014 - 15:00
Qlik, (NASDAQ: QLIK), a leader in user-driven Business Intelligence (BI), and Cloudera, a leader in enterprise analytic data management powered by Apache Hadoop™, today announced that they will host a free joint virtual event to help participants better manage big data to achieve insights and leverage Business Discovery to improve decision making.
Categories: Latest News

Your best friend calls you and asks you for the name of that...

Squirro Blog - June 17, 2014 - 08:45

Your best friend calls you and asks you for the name of that hotel you stayed sometime last March on weekend outing.

Finding this email(s) in your mailbox is hard. Better, was hard… With Squirro for Exchange we turned searching your mailbox into a breeze.  

See for yourself over here.

International Manufacturer Uses QlikView for More Insight into SAP&lt;sup&gt;&#174;&lt;/sup&gt; Data

QlikView press releases - June 16, 2014 - 15:00
Qlik (NASDAQ: QLIK) a leader in user-driven Business Intelligence (BI), today announced that Zehnder Group, an international manufacturer of heating, ventilation and cooling systems, and air cleaning solutions, uses QlikView group wide to analyze key performance indicators (KPIs) across their organization.
Categories: Latest News

QVSource On QlikMarket - Still Number One!

QV Source Blog - June 14, 2014 - 04:00

We are delighted to say that after more than two years on QlikMarket, QVSource continues to maintain its position as the highest rated product, and is doing so by a significant margin with almost 60 five star reviews!

The chart below tracks the accumulation of these ratings since early 2012 when we were invited to be one of the first products on the then beta version of QlikMarket.


What we are particularly pleased to see is that the ratings are steady and consistent over time, which we believe reflects the way we have continually been both pushing the product forward with new connectors and other innovations. Following the success of winning the Qlik Technology Partner of the Year 2014 Award, we're focused on continuing to deliver an excellent solution and service to our customers helping them to derive even more value from their QlikView investment.

Below are a couple of sample quotes from the ratings - you can read more here.

If you would like a free trial of QVSource - The QlikView API Connector and highest rated product on QlikMarket, please just visit our website.

Brilliant...QVSource fills a very needed functionality for Qlik. Innovative Product with Great Support....I feel QVSource is an innovative product that is unique in the QlikView market place, and it fills a valid need in the world of QlikView data connectivity and extraction. Excellent tool and first class support...I love QVSource, plain and simple. I work frequently with open data and find QVSource a perfect fit to the visual capabilities within QlikView. The ease with which public and corporate API's can be accessed, configured and presented to QlikView is something which makes this product, in my mind, a must for any QlikView developer. Excellent connectivity system...This has to be the easiest way of connecting QlikView to a whole stack of web data sources. The installation couldn't be easier. QVSource makes connecting to web services as easy as possible and writes the QlikView script elements to access the data for you. The support material is very comprehensive and the support response is quick and intelligent. Great connector for Social Media...Great product and great team ! Easy to install and easy to use... The best way to load and manipulate all social media data in a single QlikView app.Love it :) Works like a charm...Installed one more connector and it worked as well as the other ones. Great job

Fact: 82% of Financial Institutions surveyed do not combine data!

Squirro Blog - June 3, 2014 - 09:34
75% of companies who took part in our financial Institute Survey said combining structured and...