Business Intelligence Archives

QlikView Preserving Dates in Crosstables

The data transformation tools in QlikView are amazing. When I think of the hours I have spent working with data that was output by some system trying to get that data into a format that I could then START modeling. Oh, the wasted man hours.

One of the QlikView transformation tools has the ability to take a crosstable (like a pivot table in Excel) and convert it into a straight table; a traditional flat table where data typically starts.

CTDates1

The only problem with this tool is that it converts all of the data in the crosstable into straight text. This means that even if you see data that looks like a date (ex: 11/25/2015), it is really just a collection of numbers and slashes. QlikView does not understand what these numbers represent. This makes modeling the data a bit problematic.

What is QlikView? Creating Dashboards from Excel and Other Data Sources using QlikView

What is QlikView? Creating Dashboards using QlikViewWatch this video on YouTube In this webinar, you’ll see how to create dashboards and data visualizations with data from Excel and other data sources using QlikView. For more on our QlikView Training Courses visit our QlikView Training page.

QlikView “Allocated Memory Exceeded” Error – An Easy Check

If you have worked with QlikView and encountered the error message “Allocated Memory Exceeded”, there could be numerous reasons for this message. You may have a quite a quest in store for yourself to figure out what the issue is. But there’s quick and easy thing to check that may just be the reason for your plight.

If you have been writing expressions, one of the primary culplits for generating this memory error is a simple syntax error with your expression.

Here’s just such a scenerio: You have created a fantastic pie chart and wish to add some intelligence to the chart.

QlikView 11 Script Editor Color Codes

Have you ever been looking at your scripts in QlikView and thought to yourself, “What do all these different colors represent?”

QV1

Well, puzzle yourself no further. I am here to explain what all of these colors are trying to say and then show you how to change them if you have your own color preferences.

PowerPivot Tutorial

Microsoft PowerPivot TutorialWatch this video on YouTube In this Microsoft Excel PowerPivot tutorial, you’ll see how to use Microsoft Excel PowerPivot to import data from multiple data sources, link the data based on common fields and finally create a PivotTable and PivotChart to quickly analyze …

QlikView Training

SkillForge is happy to announce QlikView Training – offered both as live, onsite classes and live, online classes. Business Intelligence is a major area of interest to most companies these days. With data stored in multiple different sources (mainframes, client server databases, etc.) – …

Read More