Selections on list box and calendar

[Anonymous]

!Hi All,

I have been struggling with this for hours .upon continuous investigations with my problem i could find out few causes for my problem .

I have list box and calendar object.

List box has value Day,MTD,Ytd

Calendar object Sales_date

My requirement is upon selecting particular date i need to know ytd,mtd and day values for that particular date .

Lets Assume i need to find net sales for particular date i.e 2/2/1014.

First i select date and any value from list box (any of the value mtd,ytd,day)  then i get the desired result .

for the same date with out changing the date value ,if i select any of list box value then values is the calendar is getting clear.

I need calendar shouldn't be cleared .

Please find the attachment

[vardhancse]

Hi,

You don't want to clear the selection in calendar. that is what you are expecting.?

[Anonymous]

Yes !!

I dont want to clear the selections in calendar.I want the same date(what ever i selected ) should be displayed if i select mtd,ytd,day.

Thanks

[vardhancse]

If you dont want to pass the selections from the list box to the calendar, then create one alternate state and assign to the list box and to the object you want to see the selections pass.

So that filters from list box will pass only to that object with same alternate state.

[Anonymous]

Hi

But i need to fetch data for that particular date with respect to mtd or ytd or day.

will it work ?

[svenkita]

If you have a look at you data

DATE_KEY in Fct_Sales is listed

eg : 20150802

and DATE_KEY in the Cal_TimeGranule is

eg: 41638 in the Julian format

Try Changing you Fct_Sales so that the DATE_Key is represented in the same format that should solve your issue.

[Anonymous]

Hi

I tried but i problem is not resolved.

[Anonymous]

I tried with alternate states .It's not working

Thanks

[Anonymous]

Hi

I have changed as per your suggestions.

Now my calendar is not getting cleared .but i can get data for only any one list box selection value.(either mtd or ytd or day)

[Anonymous]

Hi All,

My selection is not getting applied on  CY_GROSSSALES which is in fct_sales.