Discussion board where members can learn more about Qlik Sense App Development and Usage.
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
If you have date field then calculate financial year as yearname(Datefield,0,4)
i dont have date field,
i have month,year,sales,quarter and so...
What is the format of month?
it like jan, Feb .......
It might help.
i didn't find any attachment here
can you send again
i am not getting any attachment here
Script used in app
Load *, yearname(monthstart(Date#(Month &' '& Year , 'MMM YYYY')),0,4) AS DateField;Load * inline [Month, YearJan,2016Feb,2015Mar,2016Apr,2016