differnt sheet for different edit script - Qlik Community

Anonymous · ‎2012-07-23

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.

MayilVahanan · ‎2012-07-23

HI,

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.