Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
2)
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
id orddt | qtysld |
2 22/06/2012 | 10 |
3 28/02/2012 | 20 |
4 07/01/2012 | 30 |
2 04/07/2012 | 40 |
can i write in load script while orddate between ordstdt and ordenddt then it pick that particular rate and multiply qtysold in trans table.
HI,
By using interval match concept, you can link orddate between ordstdt and ordenddt.
You can refer about in reference manual or below posts:
http://community.qlik.com/message/192808#192808
http://community.qlik.com/message/222133#222133
Hope it helps