How to get date only as per a selection

[ashishtams]

Hi All

I want to show the dates in the list box as per the selection of a dimension.

eg. I have "Transaction Name" as a dimension in a seperate table and i have 't_date' which i have used as Date(t_date) in the list box.

So now if i select a transaction name from the list, then out of all the dates it should only show those dates in the drop down which are for that selected transaction.

Note: i dont have Transaction Name ad Date in the same table.

Transaction Table is present in one table and the Date is shown as a drop down list.

Thanks for your help.

Ashish

[lironbaram]

hi for the list box you can use something like

aggr(only({<t_date=p(TransactionDate)>}t_date),t_date)

[jagan]

Hi,

Try Hide Excluded option in

List box Properties -> General

Hope this helps you.

Regards,

Jagan.

[ashishtams]

Hi,

I am sorry, I have the date in the multibox (as a drop down).

I tried your expression, but i am not getting anything in the drop down. I am not able to do a drop down now

Ashish

[ashishtams]

Hi,

Yes, thats a option for list box... i mistakenly mentioned list box.

I have the date in the  multi box as a drop down...and i see all the dates in the drop down even though they are not for the selected transaction name

Ashish.

[jagan · Accepted solution]

Hi Ashish,

The same option available in Multi box also, Try like this

Multibox Properties -> Presentation -> Click on Dimension -> Select Hide Excluded option.

Regards,

Jagan.

[ashishtams]

Hi

That option works but in my case this is some more tricky

I have the date filter as well, like if i select the Transaction Name then the Date which by default gets selected is the max(t_date) through a sheet trigger.. i.e the data for transaction is always shown as latest data.

But customer has a option to change the date from the drop down multi box. Now here,  in this multi box i ill see only one date if the I select your option "Select Hide Excluded". i need some calculation which will help me show the dates which are there for that Transaction Name. and by default is shows the max date.

So for max date i have already put the trigger. but i need only those dates for the selected transaction name.

Ashish

[ashishtams]

Any idea anybody?

[lironbaram]

can you upload a sample model so your requirement will be clearer

[PrashantSangle]

Hi,

try

Create Multibos using Expression

aggr(t_date,t_date)

Regards