topic Re: Auto selecting other column based on selection in QlikView

Auto selecting other column based on selection

Anonymous — Mon, 12 Oct 2015 15:40:20 GMT

Hey buddies,I have two date columns one has Invoice date and other column has Paid date.If I select the invoice date then automatically the closest paid date to that invoice date should get selected.How to implement this.

As shown In the above picture.If I select Notified date 5/14/2014 then closest date in Paid date box 06/27/2014 should get selected.

Re: Auto selecting other column based on selection

Mon, 12 Oct 2015 15:43:37 GMT

question - closest paid date be greater than, less than the notified date?

what if there is a date that is the same number of days away where one is higher and one is lower? which one should be chosen?

what is the use case? are both dates associated to the transaction in your data model?

what happens if user selects the paid date

Re: Auto selecting other column based on selection

Anonymous — Mon, 12 Oct 2015 15:47:17 GMT

Paid date will be always greater than Notified date.

If there is a date same number of days away then auto selection should be on lower date in paid date column.

Re: Auto selecting other column based on selection

Mon, 12 Oct 2015 15:51:59 GMT

so there will not be a scenario where the closes paid date would be less than the notified date

Re: Auto selecting other column based on selection

Anonymous — Mon, 12 Oct 2015 15:55:16 GMT

Yeah,Customer will get payment notification after the invoice gets generated.So assuming there is no issue with data entry,Paid date should come only after the invoice date.