Advertisements

iPhone like badges in #Qlikview

Posted on March 26, 2012 by mellerbeck

First off I had no idea that they called those little popup numbers on the iPhone ‘Badges’ until a co-worker told me. Anyways, was doing an AR-Aging Qlikview and thought it would be informative to show the amount of invoices for the various ‘buckets’ It’s not anything special, just round text objects. Basically one with Red background and white border and then another text object with a black background slightly larger in order to get the correct red center, white outline, and final black outline.

Somewhere online I found that to make a round text object use a Squareness of 2, and then Relative (%) of 100

 

So the finished product looked like this

Advertisements

Filed under: Qlikview | Leave a comment »

Recreating a drill down type website in #Qlikview

Posted on March 26, 2012 by mellerbeck

We have a pretty useful website for looking up our production orders (we make frozen veggies). The trick was to #qlikview-a-fy-it to get instant results.

So, this is what the original web based app looked like.

Then when a production order is clicked on, it shows more detailed information about that production order.

So, then how do you go about Qlik-View-A-Fying it?

Under the ‘show’ section of another table I used the condition

=if(GetSelectedCount(Order)= 1,1,False())

Order being the clickable object. So once you click on an order the order detail ‘magically’ appears. Same thing for when you click on an item, the next level of detail is conditionally shown in a table.

Filed under: Applied IT, Qlikview | Tagged: | Leave a comment »

Qlikview Column() Function

Posted on March 22, 2012 by mellerbeck

Not to be confused with the ColumnNo

ColumnNo([total])

Returns the number of the current column within the current row segment in a pivot table. The first column is number 1. 

Column() will return the value in that column.

The count starts from 1 for the first expression. 

—

Column(ColumnNo)

Returns the value found in the column ColumnNo in a straight table or a pivot table. 

Filed under: Uncategorized | Tagged: | Leave a comment »