About these ads

#Qlikview Responsibility Box

Posted on April 24, 2013 by mellerbeck

So this is a simple idea so that users know who to go to with questions about specific Qlikview i.e. who is the ‘SHMEEEE ‘

So use a variable in the load script

vDocOwner = ‘youremailaddress@somewhere.com’

Now create a text object displaying the vDocOwner

If you want to be extra fancy (For extra fancy you can even include the name of the document in the subject…. & subject=)

In its properties, on “Action” tab, choose : “Open URL”

In the command line, write :

mailto:noone@nowhere.com

Now if they click on they can send the responsible party an email….

There, enjoy extra responsibility responsibly

responsiblity

 

 

Also, I should make a link to a wiki page that describes the Qlikview but I will save that for later.

About these ads

Filed under: Qlikview | Leave a Comment »

#Qlikview rules of thumb

Posted on April 23, 2013 by mellerbeck

This is a short list but will continue to add more. These are mainly coming from the Qlikview masters summit

Declare all variables in the script (Especially important if you use source control)

Drop the seconds from DateTimeStamps if not needed (probably not needed most of the time)  I’ve been using cast(TheDate as Smalldatetime) as TheDate as a SQL way of doing it (any better ways??)

IF’s are evil, especially if the execute for every row

Filed under: Qlikview | Leave a Comment »

How I’ve been #Qlikview ing lately, update

Posted on March 1, 2013 by mellerbeck

So in addition to the below

http://michaelellerbeck.com/2012/09/13/how-ive-been-qlikviewing-lately-qlikview/

And I also started using subversion for source control

http://michaelellerbeck.com/2013/02/19/source-control-subversion-with-qlikview-11-2/

I also like to make a simple little deploy .bat file. This guy copies over my changes, and then runs an EDX command (setup your reload with an EDX task) This way I can check my changes on the server.

Basically:

xcopy “C:\Working_Qlikview\Financial Statement New.qvw” “\\qlikview\c$\Qlikview\QlikView Storage\Private Data\Source Documents\In Production\Accounting\Stuff.qvw”

@ECHO OFF
ECHO Please Wait While Data Refreshes
\\qlikview\QMSEDX_CommandLine\qmsedx -task=”Distribute Stuff” -qms=http://qlikview:4799/QMS/Service -password=apassword

 

Filed under: Qlikview | Tagged: | Leave a Comment »

Some #Mobile #Qlikview Designs

Posted on February 25, 2013 by mellerbeck

So I have been working on setting up some scorecarding and dashboarding Qlikviews for display on iphone/ipads. One design tip: design it to be readable on an iphone and it will look perfect on an iPad.

So for lack of a better name I call the top of our “BI” pyramid the scorecard. This is simply a rolled up grade of some metrics.

It looks like this:

scorecard

 

If something concerns you (or you want to know more, you simply press say the Bookings KPI) and that will open up the Bookings KPI Dashboard. I did this with an ‘Open URL’ Action and the use the

‘AJAX’ link to the qlikview http://qlikview.nffc.local/QvAJAXZfc/opendoc.htm?document=Sales/BookingsKPI/BookingsKPI.qvw&host=QVS@qlikview

bookings dashboard

 

 

Now, if you want even more specific information you can drill down by pressing the ‘To Bookings By Commodity”

 

This opens up the Bookings Commodity Dashboard

It looks like this

Notice buttons down the right (better ipad/iphone UI)

Sales Type COMMODITY customer

I use list boxes because this allows for single click (instead of click and hold which I find an annoying interface most the time) for charts I will overlay a listbox to accomplish this.

 

 

Filed under: Qlikview | Tagged: , | Leave a Comment »

Random #Qlikview Learning

Posted on February 22, 2013 by mellerbeck

Need to create a list box that actually doesn’t show the excluded values create a ListBox with an expression (Scroll all the way to the bottom when picking a field)

=aggr(Only([Commodity code]), [Commodity code])

I’m overlaying a Listbox over a Chart because with the iphone/ipad a listbox allows single click to make a selection.

—

If you need to change the background of a list box then you need to pick a different style other than Qlikview Classic, then you are able to change to background color and do transparency.

Filed under: Qlikview | Leave a Comment »

Source Control (Subversion) With Qlikview 11.2

Posted on February 19, 2013 by mellerbeck

So, we already have an SVN server setup for our RedGate Sql Source Control. It is a easy install of visualSVN. (Subversion 1.7)

I haven’t compared it yet, but eventually want to compare it with the colab net version.

This is the doc I’m working from for Qlikview source control (It’s outdated but hopefully it will work good enough)  http://community.qlikview.com/docs/DOC-3424

So I’ll download myself some TortoiseSVN 1.7.11, I had to specify that I want the command line tools (I’m pretty sure I will need these)

Based off of Page four of the Source Control Whitepaper it looks like it need to configure the Source Control Settings/SVN settings. The path in the guide is c:\program files(x86)\Subversion\bin\svn.exe

After installing tortoiseSVN it looks like there is a copy of svn.exe in the C:\Program Files\TortoiseSVN\bin\svn.exe  directory

C:\Program Files\TortoiseSVN\bin\TortoiseMerge.exe is in this dir as well

And the Merge Tool Parameters:  /base: %base /mine: %mine /theirs: %theirs /merged: %merged

Then you can check a project in, hmm so far so good it looks like it works.

 

 

Filed under: Qlikview | 1 Comment »

Creating fake list boxes in #Qlikview (So you have much more control over appearance)

Posted on January 29, 2013 by mellerbeck

So I wanted the functionality of a list box but wanted more control over its appearance. So along comes this post by John Witherspoon

http://community.qlikview.com/message/119349#119349

I agree that this should probably only used in limited situations but in my case I just wanted a simple selection of year and period.

Basically create straight chart with no expression

Then use the Background Color of the Dimension with a formula

=if(len(Employee),rgb(80,80,80),black())

To determine the color

Same with the Text Color

And text format

=if(len(Employee),’<b>’)

 

Filed under: Qlikview | Leave a Comment »

Initial Selection with Ajax and Qlikview

Posted on January 29, 2013 by mellerbeck

Often times especially with mobile qlikviews you want to set an initial selection. Unfortunately the OnOpen trigger is not supported with AJAX mode (which is the best way of accessing qlikviews with a mobile device)

How to best do this then?

Well at first I tried creating a bookmark and then saving the doc with that bookmark applied. Actually its interesting to use a search string to apply a variable as a bookmark. The Syntax looks something like =gl_perod_year=$(vCurrentPeriodYear)

Assuming you have Variable set with the right year data

Unfortunately this didn’t work. So I ended up using the OnOpen Trigger. Apparently, at the moment at least, if you apply a bookmark using an OnOpen trigger it seems to work well with the AJAX version. Go figure.

So, find out your bookmark ID and use that with an Apply Bookmark action

Clear as mud?

http://community.qlikview.com/message/301451#301451

 

Filed under: Qlikview | Tagged: , , | Leave a Comment »

Some methods of Learning #Qlikview

Posted on November 12, 2012 by mellerbeck

I’m always looking for ways to increase my knowledge about Qlikview. I really wish someone would write a 1,000 monster Bible on the product but Alas I haven’t found it yet.

Some things I have found:

Books on Qlikview: Hello Qlikview  This is a nice little intro guide to qlikview, this is good to hand to someone who is just starting to get into self service BI using Qlikview.

Qlikview for Enterprises This is a very indepth book about BI, ETL, and practices surrounding an Qlikview implementation. It won’t really help you learn how to script / or design though.

Qlikview 11 Developers Guide This book isn’t released yet (as of 10/9/2012) it looks like it should be pretty good

—

The next thing that I find very useful is to follow people on the Qlikview Forum and read everything that they post :)

For scripting awesomeness you should follow

Henric Cronström and Rob Wunderlich

Speaking of Henric (I wish he would write a book on Qlikview!) you should read all of his Tech documents

http://community.qlikview.com/people/hic?view=documents  I really like

http://community.qlikview.com/docs/DOC-3102

http://community.qlikview.com/docs/DOC-3155

http://community.qlikview.com/docs/DOC-3412

http://community.qlikview.com/docs/DOC-3451

And speaking of Rob you should check out his downloads http://robwunderlich.com/downloads/  he has the awesome Qlikview CookBook as well as the Qlikview Components

http://code.google.com/p/qlikview-components/

—

I also like to follow Steve Dark all of the qlikviews he publishes are extremely well done and documented.

—

So, I also like to follow a bunch of Qlikview Blogs.

If you are interested in making Qlikview look Awesome you really need to read everything by http://qvdesign.wordpress.com/

I also like http://fortunecookiebi.blogspot.com/

http://qlikshare.com/

http://www.qlikblog.at/

http://livingqlikview.blogspot.com/

http://qlikboard.com/

http://mindspank.wordpress.com/

http://oneqlikatatime.blogspot.com/

http://www.quickintelligence.co.uk/

http://qliktips.blogspot.com/

http://qlikviewnotes.blogspot.com/

http://www.qlikviewaddict.com/

http://www.qlikfix.com/

 

Filed under: Qlikview | Tagged: , | Leave a Comment »

Newest #Qlikview toy, Margin Analysis

Posted on September 21, 2012 by mellerbeck

So I recently created this little APP for accounting. It basically pulls in the costing information, last sales information, and lets you play with the margins. What happens if costs go up 2% and we increase prices by 3% and they take their 2% discount. And what if volume goes down a little on one item? That sort of thing

 

It also implemented this awesome post http://www.qlikfix.com/2012/08/22/search-by-copy-and-pasting-from-an-external-list/

So they copy and paste Products from excel into a input box and then go and select those!  This select in field string is the magic

=’(‘ & Replace(Replace(Replace(Trim(‘$(vProductList)’), ‘  ‘, ‘|’),’ ‘, ‘|’), chr(10), ‘|’) & ‘)

Filed under: Qlikview | Leave a Comment »

Next Page »
About these ads
Follow

Get every new post delivered to your Inbox.

Join 237 other followers