Logic

[smilingjohn]

Hi ALl,

Please find the attachment of the qvw file .

Here i have bar chart which has the dimesnion  defectsummaryreportperiod  this is statring form NOV ..

The requirement is like it should show the 13 months from the selected date from Orderdate and the date format is MM-DD-YYYY.

say for example now i have selcted 11-11-2017.....that means and if you look at the bar chart it is showing 13 months charts...starting from NOV 2016 to NOV 2017..

but if i select October it will show 12 months... the starting will still be NOv..

Please help me on this ...If i slect in future Dec from Orderdate then the bar chart should start from Dec... so that it will be 13 months ..

How can ia chive this ...

Thanks in advance

[amarnath_krishn]

Currently the data is available only from Nov-2016 and ends by Oct-2017.

I would suggest to create a variable to identify the start range for the rolling 13-month and use that variable in all the expressions in set analysis to limit the data.

[smilingjohn]

hi Amarnath..

Can you please help me with this ..

It will be really great..

Say for example consider it for 6 months ......

Thanks in advance

[stabben23]

You could try to add these set analysis into Your Expressions or simular:

Sum ({<DSLoadDate={">=$(=date(addmonths(DSLoadDate,-13),'MMM-YYYY'))<=$(=max(date(addmonths(DSLoadDate,0)),'MMM-YYYY'))"}>}DSCreateCount)

[amarnath_krishn]

In Expresssions:

Sum ({<DefectSummaryReportPeriod={">$(vChartRangeStart) <=$(vChartRangeEnd)"}>}DSCreateCount)

where variable - vChartRangeStart=Date(AddMonths(DSLoadDate,-6),'MMM-YYYY')

vChartRangeEnd=Date(AddMonths(DSLoadDate,0),'MMM-YYYY')

[smilingjohn]

Hi

Amarnath this is not working ..

I followed the steps you suggested ..

I dont know where i am going wrong ...

[smilingjohn]

Hi Staffon thanks for the reply

this is not working ..i followed what you suggested ..

[amarnath_krishn]

Please share the updated qvw; let me have a look.

[stabben23]

Ok, than you have to find out what not is working, because it Works for me.

[smilingjohn]

Hi Amarnath .

Please find the attachment of the qvw file where i have uodated the variable as per your suggestions.

Thanks