• Blog
  • Contact

Brace yourself - Black Friday is here

11/24/2016

0 Comments

 
[Qlik(o)graphics]

Ready or not - here I come you can hide...

​'The Fugees' song is probably a good theme for one of the most unpredictable days of the year. Are you ready?
black_friday.qvw
File Size: 433 kb
File Type: qvw
Download File

Picture
Let's talk tech
Power to the user - dynamic color change
You can dynamically change color of the application.
The final outcome is presented below:

Below is quick guide how to do that:

In Script:
1) Create variables that you going to use as colors:
 
SET  vco_1='RGB(255,0,0)';
SET  vco_2='RGB(179,0,0)';
SET  vco_3='RGB(255,128,0)';
SET  vco_4='RGB(179,89,0)';
SET  vco_5='RGB(0,0,0)';

 
2) Create inline table that will be used a list box:
//OptionsListbox
Option:
 load * inline [
 Option
 Option1
 Option2
 Option3
 Option4
 Option5
 ];

 
3) Another table will be used as colors Matrix:
ColorsMatrix:
 load * Inline [
 Option1,Option2,Option3,Option4,Option5
 '$(vco_1)','$(vco_2)','$(vco_3)','$(vco_4)','$(vco_5)',
 '$(vco_5)','$(vco_4)','$(vco_1)','$(vco_2)','$(vco_3)',
 '$(vco_2)','$(vco_1)','$(vco_5)','$(vco_3)','$(vco_4)',
 '$(vco_4)','$(vco_3)','$(vco_2)','$(vco_5)','$(vco_1)',
 '$(vco_3)','$(vco_5)','$(vco_4)','$(vco_1)','$(vco_2)',
 ];
 

*The number of colors is defined by numbers of variables:
For 3 variables the matrix will be 3x3.
In Front End

1) Create 5 variables that will used as a picker from listbox of “Options”
vco_Opt1 =$(=fieldvalue($(v_Option),1))
vco_Opt2 =$(=fieldvalue($(v_Option),2))  
vco_Opt3 =$(=fieldvalue($(v_Option),3))
vco_Opt4 =$(=fieldvalue($(v_Option),4))
vco_Opt5 =
$(=fieldvalue($(v_Option),5))

and another variable that will be used as a lookup to the orphan (Option) table:
=Chr(39)&Option&Chr(39)
 

2) Create an “Option” listbox

Picture
​Each time you create an object and you want to use one of the colors option
you need to add one of the color variables to the Calculated field window:
Picture
0 Comments

BBC Children in need - 36 years of helping disabled and young childrens

11/18/2016

2 Comments

 
Small sets of data but huge cause.
Since 1980 BBC is raising money to help childrens that need them the most.

If you would like to donate, please fallow this link --->>> DONATE
children_in_need.qvw
File Size: 599 kb
File Type: qvw
Download File

Picture
Picture
2 Comments

115 years of of Nobel Prize

11/9/2016

0 Comments

 
        [Qlik(o)graphics]
nobel_prize.qvw
File Size: 2419 kb
File Type: qvw
Download File

​Overview

Picture
​Age
Picture
How to become a Nobel Prize Laureat
Picture
​Monetary value
Picture
Picture
0 Comments

Delimiters for INLINE TablE

11/8/2016

0 Comments

 
In most cases when building Inline table, coma(,) is used as a default delimiter.
But, what if you you came across a file that have different delimiters and you need only few rows from that table?

Good news is  that there is no need to manually change every instance of that delimiter, instead you can use the 'delimiter is' statement at the end of the inline table to achieve required result.

Example below is using  '#' (hash) but in fact any ASCII sign can be assign for that purpose.

INLINE:  
Load * Inline  
[  
CATEGORY#VALUE
 SANA#1000
 MANA#2000
 PAKA#3000
]   
(delimiter is '#') ;

0 Comments

A Tableau/MicroStrategy Dashboard  Rebuilt in Qlikview

11/2/2016

0 Comments

 

After reading Len O'Toole article A Tableau Dashboard Rebuilt in MicroStrategy,
my first thought was to recreate this Dashboard in Qlikview.
As a Qlik evangelist, I wanted to see (and somehow proof) that QlikView can deliver visualisation of the same quality.
Although the data is quite small - 48 rows, Jeffrey Shaffer - author of the Tableau version, delivered very interesting and visually appealing dashboard.
​I'm not in favour of black backgrounds, but in this case which colour would be more appropriate?

Competition First...
​Tableau
Picture
MicroStrategy
Picture
and QlikView
Picture
I believe that looking at the pictures only, it would be hard to judge in which program they were created. (well, unless you know all the 3 tools inside out).
Challenges
  • Grouped line chart - not available in QlikView (yet?) - I used normal Line chart with  option  (Fast Change) to convert to grouped Bar chart.
  • Labels for Year - top alignment is not available at the moment. To match the Tableau/MicroStrategy style a copy of the chart is added as another layer.
  • "Numbers of visitors" label - another copy of the same chart is added to avoid interfering with the "Reference lines".
  • Time for maximum visitors is delivered from "Text in the chart" option. It has fewer options that normal Text box but is more dynamic as we start to filter down the chart.
Conclusion
It was a great fun to build this application.
Challenges I came across taught me that you can deliver very similar feel and look in Qlikview that can be achieved in Tableau or MicroStrategy.
You can always learn something new and seeing how many candies were collected during that years made me somehow hungry...
Although I'm Qlikview practitioner, I will be looking at this website quite often now.
Tableau has its own edge which I want to explore. 

BTW:
​In 2011 the number of visitors in Jeffrey's house was 869. For me a staggering number.I live in a small town and this year we had about 30 visitors.

halloween.qvw
File Size: 474 kb
File Type: qvw
Download File

0 Comments

    Categories

    All
    QlikView
    Tips

    Archives

    November 2016

    RSS Feed

    Subscribe to Newsletter
Copyright QlikSteps© 2016
  • Blog
  • Contact
✕