How to show only last 6 months date.

[Anonymous]

Hi,

I want to show the only last 6 months date in the chart .

Is it possible.

How to filer the date in the chart .

[Anonymous]

Ok

My requirement is

First Line chart: x axis sep, oct , nov dec, jan , feb march and y axis chrome/Firefox/IE variation since 6 months,

If i can get the first chart i can do the same logic in second chart.

[Frank_Hartmann]

Have a look at the attached qvw.

Not sure if this fit your needs. Let me know if it works!

[Anonymous]

Thank you .

Can you please explain the expresssion as the variable which i dont understand as it is in foreign language.

count({<MonthDiff={'>=$(vZeitraum6Monate)<=$(vAktuellerMonat)'}>}B)

count({<MonthDiff={'>=$(vZeitraum6Monate)<=$(vAktuellerMonat)'},B={'IE'}>}B)

[Frank_Hartmann]

if you take a look at the script you will see that i generated a mastercalendar

and some variables eg.vZeitraum6Monate and vAktuellerMonat.

the mastercalendar is generating a field called ''MonthDiff''. This Field actually assigns

a number to every month. For todays month it should assign the 0 and last month should assign the -1 and for the month before last month it should assign -2 and so on.

vAktuellerMonat (=vActualMonth)  <---   =0

vZeitraum6Monate (=vRange6Month)   <----  =-5

Because i connected the MC to your DataTable you can now define the ranges with setanalysis in order to get the wished data.

In my app which i uploaded there is a small mistake. In the script

on MC sheet on top you will have to replace

SET vAktuellerMonat = -1;  

to:

SET vAktuellerMonat = 0;

hope this helps

[Anonymous]

Thank  you so much for your  explanation..

I will try and let you  know.

Much appreciated

[Frank_Hartmann · Accepted solution]

if you take a look at the script you will see that i generated a mastercalendar

and some variables eg.vZeitraum6Monate and vAktuellerMonat.

the mastercalendar is generating a field called ''MonthDiff''. This Field actually assigns

a number to every month. For todays month it should assign the 0 and last month should assign the -1 and for the month before last month it should assign -2 and so on.

vAktuellerMonat (=vActualMonth)  <---   =0

vZeitraum6Monate (=vRange6Month)   <----  =-5

Because i connected the MC to your DataTable you can now define the ranges with setanalysis in order to get the wished data.

In my app which i uploaded there is a small mistake. In the script

on MC sheet on top you will have to replace

SET vAktuellerMonat = -1;  

to:

SET vAktuellerMonat = 0;

hope this helps