Discussion board where members can get started with QlikView.
i am new in qv
i have small queries
1)I have added 3 sheets . I want to write 3 different load script.
how can i write 3 different load script for 3 differnt sheet.
i have a master table :
id ordstdt ordenddt rate
2 21/06/2012 30/06/2012 14
3 25/02/2012 03/03/2012 12
4 03/01/2012 13/01/2012 10
2 01/07/2012 10/07/2012 15
in trans tab
can i write in load script while orddate between ordstdt and ordenddt then it pick that particular rate and multiply qtysold in trans table.
By using interval match concept, you can link orddate between ordstdt and ordenddt.
You can refer about in reference manual or below posts:
Hope it helps