Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

search and map data

Hello, i'm sure you can help me with this.

i've got a loadscript with some tables - lets call them "Sales" and "Customer". In Customer the Key-Field is No_.

Now i'd like to search for the min([Posting Date]) of every Customer.No_ in the Sales-Table. The found result should be added to the Customer-Table, the name of the field is "[first bought]"

can you explain me how this works in the loadscript?

Thank you!

Best,

Tim

1 Solution

Accepted Solutions
sujeetsingh
Honored Contributor III

Re: search and map data

Just Resident load  temp table and derieve the minumum() of the field.

Now you can easily map the minimum based on the valid Key in your data model,

by using Applymap() oe Left Join()

1 Reply
sujeetsingh
Honored Contributor III

Re: search and map data

Just Resident load  temp table and derieve the minumum() of the field.

Now you can easily map the minimum based on the valid Key in your data model,

by using Applymap() oe Left Join()

Community Browser