Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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 - Specialist
Partner - Specialist

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 - Specialist
Partner - Specialist

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".