Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculated Dimension

I want to create last three month data based on selected month

28 Replies
Not applicable
Author

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.

sc_05012015.png

Not applicable
Author

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

Not applicable
Author

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.

Not applicable
Author

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

jyothish8807
Master II
Master II

Hi Siva,

PFA

Regards

KC

Best Regards,
KC
Not applicable
Author

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

Not applicable
Author

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

sc_07012015.png

sc_08012015.png

Not applicable
Author

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

Not applicable
Author

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