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

[qlikviewwizard]

Hi Ashish,

Please try Jagan's solution. It will works. Thank you.

[ashishtams]

It worked, Thanks for your help