Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.....
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.
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.
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