topic Re: Getting My Head Around Qlikview in QlikView

Getting My Head Around Qlikview

dmac1971 — Wed, 28 Nov 2012 10:57:28 GMT

OK so I've jsut discovered Qlikview, I'm a grizzled Excel user, but need serious help with syntax etc.

For example I can create a basic dashboard with List Boxes etc. What if I loaded a table of the last 2 years sales data, and I want to only show 2012, based on the year col. I dont however want to show this col in the table. I think I need to build in an expression to only show year matching 2012, but havent a clue where to put it? Do I do it when loading the data, even though I only want to apply this to a sheet I'm looking at?

Lost.....

Re: Getting My Head Around Qlikview

swuehl — Wed, 28 Nov 2012 11:21:25 GMT

Not sure if I got your request properly, but maybe like this:

Create an OnActivateSheet trigger for your sheet (Sheet properties -> Triggers), with an Selection - Select in field action.

Set your field you want to filter (I assume Year) in the Field entry box:

Year

and as search expression:

2012

So whenever you enter this sheet, 2012 is selected in your data.

Re: Getting My Head Around Qlikview

Or — Wed, 28 Nov 2012 11:28:33 GMT

If you would like a specific table or chart to only show values for one year (or one month, or any other selection), you can use Set Analysis. You would normally put these in your Expressions, e.g.

Dimension: Month, Item Type

Expression: Sum({$<Year={2012}>}Sales)

You can use this expression in multiple charts, of course, and you don't have to make any selections for that chart to show 2012 values.

For writing out Set Analysis syntax, I recommend http://www.qlikblog.at/1384/set-analysis-wizard-qlikview/ - a handy wizard for generating set analysis statements.

Re: Getting My Head Around Qlikview

Wed, 28 Nov 2012 11:53:30 GMT

I´d would also like to suggest the set wizard in above link. Also have a look the paper found in this tread http://community.qlik.com/thread/59055