topic Re: DYNAMIC LAST EIGHT FINANCIAL MONTH in QlikView

DYNAMIC LAST EIGHT FINANCIAL MONTH

Sat, 05 Jan 2013 07:18:13 GMT

Hai,

how to i get last dynamic last 8 months in fin calendar

ex: this is dec if i select dec-2013 then show below out put

may

jun

jul

aug

sep

oct

nov

dec

same way if i selet full year ex 2012 i have all months so out put wil be

aug

sep

oct

nov

dec

jan

feb

mar

pls give me any idea its rearly help for me

Re: DYNAMIC LAST EIGHT FINANCIAL MONTH

Sat, 05 Jan 2013 08:22:03 GMT

i am getting data but wn i select year values showin fine but wn i select month the order is not showing fine

can i send my logic ans variables

Re: DYNAMIC LAST EIGHT FINANCIAL MONTH

er_mohit — Sat, 05 Jan 2013 12:49:59 GMT

send me your logic ans variable

you shuld write dual for month also

in above script

DUAL(Year(DATE) & Ceil(dual(MONTH(DATE)-4),Year(DATE) & Ceil(MONTH(DATE)-4))) AS EGHITYR;

hope it helps..

if it might be either helpful or correct answer to you then mark it as helpful or correct answer. because doing this it can be helpful for lot of developers.