Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
MayilVahanan

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

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