Current Week OnOpen Macro

so I don't forget...


Sub OnOpen

InitialSelections

End Sub

Sub InitialSelections
ActiveDocument.Fields("Cal.RelativeWeek").select "0",True
ActiveDocument.Fields("Cal.WeekStartMon").selectpossible
ActiveDocument.Fields("Cal.RelativeWeek").clear
End Sub

Syntax for Alternate States:

ActiveDocument.GetField("CUSTOMERS", "State1")

GeoAnalytics points...

City state is "Location Named Point"

'[-118.243685,34.052234]' is "Point"

Long Lat in separate fields is "Latitude and Longitude Point"

NPrinting Exporting Numbers as Text...grrrrr

At first, I was   (╯°□°）╯︵ ┻━┻   and   ლ(｀ー´ლ)  and   ಥ_ಥ  and just about became a
 ““”̿ ̿ ̿ ̿ ̿’̿’̵͇̿̿з=(•̪●)=ε/̵͇̿̿/̿ ̿ ̿ ̿ ̿’““  ! No matter what I did, NPrinting would export my darn tables as text! If it could only translate the values to numbers like I can translate text emoticons into feelings.

calculating...calculating...calculating...calculating...calculating...calculating...

At first, I was flipping tables and angry face and sad and just about became a crazed gunner! Then, I found and adapted an Excel macro that gave me a ヽ(´▽`)/  .

Days : Hours : Minutes

The Qlik Community comes through again!

I need to turn a buck of minutes into a Days : Hours : Minutes format.

It was as simple as:

=Interval(Interval#([your minutes],'m'),'d:hh:mm')

New Beginner Course on PluralSight!

Go watch my new PluralSight course!

http://www.pluralsight.com/courses/qlikview-create-data-discovery-tool

It's intended for the absolute beginner, so keep that in mind when you send me your accolades!

And for those that come here for the jokes....

When my wife told me to stop impersonating a flamingo I had to put my foot down.

Circle Takes the Square

Did you ever think to yourself, "Why was Paul Lynde always the center square? What's wrong with Soupy Sales? And for hell's sake, shouldn't Charo be the center of everyone's game show universe?"

If you did, then you were also alive the last time I posted a tip. So, quicker than you can say 'cuchi cuchi', here's your Tip:

Make a Round Text Object

Missed it by that much...

You've built a beautiful chart. Removed the Caption Bar, because we all know those are ugly. You changed the Title Settings to Divider, Left Justified. It's so beautiful that you want to copy it and use it with another metric. Just Ctrl-click and drag, but you missed the border by that much...

Try 99 times Agent 86, but you're too shaky. You should have had the small Red Bull, not the big one. That crosshair just won't stay on the border!

What to do? So simple you don't even have to click through to suffer through more bad jokes...

Just hold down Ctrl+Alt while you click and drag. You can click anywhere on the object. You can have the big Red Bull and not worry about the shakes. I wish I would have known about this a couple of years ago.