Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

kkoyyalamudi
Contributor

Auto selecting other column based on selection

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.

Capture.PNG

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.

4 Replies
Not applicable

Re: Auto selecting other column based on selection

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

kkoyyalamudi
Contributor

Re: Auto selecting other column based on selection

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.

Not applicable

Re: Auto selecting other column based on selection

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

kkoyyalamudi
Contributor

Re: Auto selecting other column based on selection

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.

Community Browser