Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

laxmanqlik
Contributor

How to represent a financial calendar

hi Every one,

i have a requirement that i have to represent the data of particular financial year like Apr2015 to Mar 2016

can any one let me know the way to do that

thanks in advance

15 Replies
shraddha_g
Honored Contributor III

Re: How to represent a financial calendar

If you have date field then calculate financial year as yearname(Datefield,0,4)

laxmanqlik
Contributor

Re: How to represent a financial calendar

i dont have date field,

i have month,year,sales,quarter and so...

shraddha_g
Honored Contributor III

Re: How to represent a financial calendar

What is the format of month?

laxmanqlik
Contributor

Re: How to represent a financial calendar

it like jan, Feb .......

shraddha_g
Honored Contributor III

Re: How to represent a financial calendar

See attached.

It might help.

laxmanqlik
Contributor

Re: How to represent a financial calendar

sorry

i didn't find any attachment here

can you send again

shraddha_g
Honored Contributor III

Re: How to represent a financial calendar

PFA

laxmanqlik
Contributor

Re: How to represent a financial calendar

sorry Shraddha,

i am not getting any attachment here

shraddha_g
Honored Contributor III

Re: How to represent a financial calendar

Script used in app

Load *, yearname(monthstart(Date#(Month &' '& Year , 'MMM YYYY')),0,4) AS DateField;
Load * inline [
Month, Year
Jan,2016
Feb,2015
Mar,2016
Apr,2016

];

Community Browser