Regarding Period Exp

[d_koti24]

Hi ,

i Have field period,

Period	sales
1/30/2015	100
2/27/2015	50
3/31/2015	500
4/25/2015	200
5/29/2015	150
6/01/2015	100
6/02/2015	015
6/05/2015	22
6/06/2015	555
6/08/2015	666
6/10/2015	777

In bar chart i want show the all month end dates with current selection period

ex:

if i select 6/08/2015 in period

i want show bar chart with these values

1/30/2015  2/27/2015  3/31/2015  4/25/2015  5/29/2015  6/08/2015

if i select 6/10/2015 in period

i want show bar chart with these values

1/30/2015  2/27/2015  3/31/2015  4/25/2015  5/29/2015  6/10/2015

how to achive this?

[Mark_Little]

Hi,

One possible method would to use a variable.

vSelectedDate

=GetFieldSelections(Period)

Then in your expression use something like below

=SUM({1<Period={"<=$(vSelectedDate)"}>}sales)

Mark

[maleksafa]

Hi,

Please check the attached example on your data set. you need to modify the expression and use the possible P() in the set analysis.

[d_koti24]

Hi Malek,

Thanks for quick response...!

but

I want all the month ends in a bar as well as current selection in this month.

[maleksafa]

what do you mean by month ends? is it the highest value per month, or you want to accumulate up to the selected date?

[Anonymous]

If I am not wrong, you want whatever period you selects, it should give all the data of periods which is less than or equal to your current selection?

[d_koti24]

Highest value of month(.max date )

[sasikanth]

HI,

Take Dimension "PERIOD"

write exp like

=sum({<Period={'<=$(= MonthEnd(addmonths( max(Period),-1)))','$(=max(Period))' }>} sales)

Hope it will helps you

[d_koti24]

Hi Sasi ,

can you please attach the sample qvw.

[sasikanth · Accepted solution]

HI , please find the attachment