Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

anutosh_dhar
Contributor

differnt sheet for different edit script

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.

1 Reply
Highlighted

Re: differnt sheet for different edit script

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

Community Browser