So you have written your first few reports, your company has gone wild for Qlikview and know it's time to think about how you're going to implement security on your reports.
This is the first of two parts on section access, Section Access is how Qlikview restricts data based upon your login.
Half guides, half a repository of my Qlikview knowledge. A smattering of links to other cool Qlikview stuff.
Monday, 16 July 2012
Section access - part one (including inline wizard)
Labels:
Business Intelligence,
Data,
inline,
Intermediate,
Load,
load inline wizard,
Qlikview,
Script,
section access,
security,
Tables
Monday, 2 July 2012
Qlikview Charts with Colours
Matt over at Qlikview Addict, recently posted about how to create Gantt Charts in Qlikview.
Here's my quick post about how I customized my Gantt chart to colour my chart based off dates and adding a couple more data guidelines. Please note that you will need to follow the original article before starting this...
Here's my quick post about how I customized my Gantt chart to colour my chart based off dates and adding a couple more data guidelines. Please note that you will need to follow the original article before starting this...
Labels:
Basic,
Business Intelligence,
Charts,
Data,
Dates,
Design,
Qlikview,
Reference Lines,
Tables,
Text in Charts
Tuesday, 19 June 2012
Back door access to your Qlikview report
So you're working on a Qlikview document and then the next day you can't open it
We've all been there, maybe you're playing around with the relationships in your data. Saved your work and then you open it and the charts trying to generate crashes your pc.
Or maybe you’ve been working on a report all day, got your data right and take it home to make your charts and your laptop hasn’t picked up a license from the server before you left.
Here’s a couple of ways you can save your reports and a quick note on limiting other people’s access to your data.
We've all been there, maybe you're playing around with the relationships in your data. Saved your work and then you open it and the charts trying to generate crashes your pc.
Or maybe you’ve been working on a report all day, got your data right and take it home to make your charts and your laptop hasn’t picked up a license from the server before you left.
Here’s a couple of ways you can save your reports and a quick note on limiting other people’s access to your data.
Tuesday, 12 June 2012
Quick Region Maps
So you need to map out your data but you either
- Don’t have database access
- Want to define your regions as per your client's request
- NEED IT DONE YESTERDAY
Labels:
Business Intelligence,
Charts,
Data,
Design,
Input Box,
Intermediate,
Maps,
Qlikview
Friday, 1 June 2012
Hello Qlikview!
Hello Qlikview!
I'm currently reading through this book, it's aimed as an introduction to Qlikview for complete novices and has got some nice examples so far.
I'll be posting a full review once I have finished it.
Labels:
Business Intelligence,
Connection,
Opinion,
Qlikview,
Script
Thursday, 24 May 2012
Sometimes it's so simple it's too obvious - drawing circles in Qlikview
Saturday, 12 May 2012
In Statements in Qlikview - Match()
I don't know about everyone else but I have often googled for how to do an in statement in Qlikview.
#Note by an In statement I am referring to how to test one value against multiple values or a range of values
As searching for the word "in" in relation to Qlikvew is nigh on impossible here's a quick post explaining how to do it and how to use it for custom sort lists:
#Note by an In statement I am referring to how to test one value against multiple values or a range of values
As searching for the word "in" in relation to Qlikvew is nigh on impossible here's a quick post explaining how to do it and how to use it for custom sort lists:
Location:
Unknown location.
Subscribe to:
Comments (Atom)