Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Is It Possible A Dimension from more then one field ??

Dear All,

Is it possible that can we make a dimension from 3 differnt fields ?

Case :

I have table like this

ROWFinancial YearLast  1 YearLast  2  YearLast  3 Year
12011-20122010-20112009-20102008-2009
22010-20112009-20102008-20092007-2008
32007-20082006-20072005-20062004-2005

On the selection of Financial Year 2011-2012 I want the Dimension of straight table will show last 3 year along with the selected year

Please guide me in this case or any workaround ASAP

Thanks & Regards

-anil

4 Replies
vijay_iitkgp
Partner
Partner

Hi Anil,

Can you please provide the required format in Excel

regards

Vijay

Not applicable
Author

Dear Vijay,

Thanks for very quick reply,

please get attached excel of result required

-anil

nstefaniuk
Creator III
Creator III

You can use a set analysis.

Something like (for "Qty Total") : sum({$<Financial Year = {"<=$(=Financial Year)>=$(=Financial Year-2)"}>} Qty)

Of course, Financial Year should be a number else you can't easily do a -2 on it.

It will display in the chart 3 lines when you select only 1 Year in the list box

kuba_michalik
Partner
Partner

You could create a table in script which links every fiscal year to itself and last 3 years. Something like this:

Select  YearYear
2011-20122011-2012
2011-20122010-2011
2011-20122009-2010
2011-20122008-2009
2010-20112010-2011
2010-20112009-2010
2010-20112008-2009
2010-20112007-2008

"Year" is the same field as the one in fact table and it links the two tables.

Use "Year" as table dimension, however make your selections on "Select Year".