topic Re: Logic Help in QlikView

Logic Help

abhaysingh — Wed, 10 Feb 2016 14:13:55 GMT

Hi GUys,

I have one fiscal year like 2012,2013 = Calendar year 2012

2013,2014 = Calendar year 2013

2014,2015 = Calendar year 2014

2015,2016 = Calendar year 2015

I want the fiscal year to be shown like 2012 for 2012 ,2013

and 2013 for 2013,2014

i want it dynamic, if new year comes than this process automate and give me next year.

how i can do this?

i think it can be done by loop, any suggestion?

Re: Logic Help

swuehl — Wed, 10 Feb 2016 14:15:47 GMT

Maybe like

LOAD

Subfield( [Fiscal Year], ',',1) as [Fiscal Year],

...

Re: Logic Help

MK_QSL — Wed, 10 Feb 2016 14:18:23 GMT

Date#(SubField('2012,2013',',',1),'YYYY') as FiscalYear

Re: Logic Help

abhaysingh — Wed, 10 Feb 2016 14:22:00 GMT

not working

i want to represent fiscal year as my calendar year..

by above getting same output

Re: Logic Help

MK_QSL — Wed, 10 Feb 2016 14:23:45 GMT

How your Fiscal Year field is and how you want to show !

Re: Logic Help

abhaysingh — Wed, 10 Feb 2016 14:25:10 GMT

I think i miscommunicated .. sorry for that,

i have fiscal year like below

2012

2013

2014

2015

2016

and calendar year

2012

2013

2014

2015

so when i m selecting 2012 calendar year, fiscal year 2012 and 2013 highlighted. so i want to show this fiscal year as single field having value as calendar year which is 2012.

Re: Logic Help

Anonymous — Wed, 10 Feb 2016 14:29:01 GMT

my customer too has a fiscal year whicjh differs from calendar year

I provided a mastercalender with additional fields for fiscal year, fiscalmonth etc.

so January 2016 is fiscal year 2015 with fiscal month nr 10

Re: Logic Help

MK_QSL — Wed, 10 Feb 2016 14:30:24 GMT

are they in single table or different table?

Re: Logic Help

abhaysingh — Wed, 10 Feb 2016 14:38:16 GMT

yes they are in single table

Re: Logic Help

MK_QSL — Wed, 10 Feb 2016 14:41:45 GMT

can you provide some sample data with 4-5 lines...?