Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to create last three month data based on selected month
And if I select Jan 2014 , with a 12 rolling period analysis. It shows me this, because you only have 3 months per year in your data.
Dear Mario Estrada
Thank u
Let me clarify one this if i select jan 2014 i should display dec 2013 and nov 2013 oct 2013 .It should be for air and sea
if i select may 2014 it should show feb 2014 mar 2014 apr 2014 like this plz help me to achive this use ur own variable
Thanks
sivaram
Yes, now it works as expected, further more I put the slider to go from different rolling periods 3,4,5,6, months, etc. and yes, if you select jan 2014 it will roll thu dec 2013 etc. etc.
Dear Mario Estrada
send me qvw
i don't want through slider i will keep selected current month in input box like 01;02;03;04;05;06;07;08;09;10;11;12;
based on selected month from input box the chart values have to change
i have two input box's current selected year and current selected month if select current selected year as 2014
and selected month is jan i should get dec 2013,nov 2013, oct 2013
This is my exact requirement plz help in this
Thanks
sivaram
Hi Siva,
PFA
Regards
KC
Dear Jyothish Kc
Thank you
i don't want through slider i will keep selected current month in input box like 01;02;03;04;05;06;07;08;09;10;11;12;
based on selected month from input box the chart values have to change
i have two input box's current selected year and current selected month if select current selected year as 2014
and selected month is jan i should get dec 2013,nov 2013, oct 2013
This is my exact requirement plz help in this
Thanks
sivaram
Sivaram,
I was sure you could figure out your solution based on the qv file and my explanation. The slider I placed there were just to make sure as a test case that the rolling period was working . Anyway, I am enclosing the solution and some screen shots. but let me tell your some extra info. 1) The two input boxes are being triggered to select their values in the database otherwise the yearmonthserial column won't work. 2) Your code for month should not contain '' single quotes in the little table you placed on the main2 tab on the script editor. 3) it works as expected I placed some data for dec and oct in my own environment and it is working fine , the qv enclosed is your version meaning your data and your loading of your qvd file at home and 4) you should consider always to create a master table for a time dimension, otherwise you will never be able to roll over time.
Hope this helps,
Mario Estrada
Dear Mario Estrada
Thanks once again
My chart should always show three months data if data is not their also it should show month name at least
if is selected month 3 it want to show feb 2014 and jan 2014 i want dec 2013 in that
Thanks
sivaram
Dear Mario Estrada
i have achieved one i am not able to achieve other plz let me give some idea how to achieve
i am attaching qvw file plz go through it and advice me
if i select month 1 2014 i want to show three months data that is dec 2013 nov 2013 oct 2013
that is my aim
Thanks
sivaram