topic Re: How to get date only as per a selection in QlikView

How to get date only as per a selection

ashishtams — Tue, 01 Sep 2015 09:23:41 GMT

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

Re: How to get date only as per a selection

lironbaram — Tue, 01 Sep 2015 09:30:12 GMT

hi for the list box you can use something like

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

Re: How to get date only as per a selection

jagan — Tue, 01 Sep 2015 09:45:22 GMT

Hi,

Try Hide Excluded option in

List box Properties -> General

Hope this helps you.

Regards,

Jagan.

Re: How to get date only as per a selection

ashishtams — Tue, 01 Sep 2015 09:55:12 GMT

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

Re: How to get date only as per a selection

ashishtams — Tue, 01 Sep 2015 09:57:24 GMT

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.

Re: How to get date only as per a selection

jagan — Tue, 01 Sep 2015 10:06:45 GMT

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.

Re: How to get date only as per a selection

ashishtams — Tue, 01 Sep 2015 10:20:46 GMT

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

Re: How to get date only as per a selection

ashishtams — Tue, 01 Sep 2015 11:28:45 GMT

Any idea anybody?

Re: How to get date only as per a selection

lironbaram — Tue, 01 Sep 2015 13:26:11 GMT

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

Re: How to get date only as per a selection

PrashantSangle — Tue, 01 Sep 2015 13:32:22 GMT

Hi,

try

Create Multibos using Expression

aggr(t_date,t_date)

Regards

Re: How to get date only as per a selection

qlikviewwizard — Wed, 02 Sep 2015 02:15:35 GMT

Hi Ashish,

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

Re: How to get date only as per a selection

ashishtams — Wed, 30 Sep 2015 04:58:31 GMT

It worked, Thanks for your help