Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gauravgg
Partner - Creator
Partner - Creator

Create a qvd by year

Hi All ,

 

I have the following table .

Material , Vendor , Plant ,Valid from , Valid to  ,Price.

form the above table i have to create qvd   Year wise Price for Material ,Vendor ,Plant combination ie. as follows 

Material , Vendor,Plant , Year ,Price 

 

Thanks in Advance

 

 

Labels (2)
1 Reply
miskinmaz
Creator III
Creator III

Hi,

You can follow below steps:

1. Temp table with only Year dimension;

2. for loop till no of rows of tep table.

3. peek year from temp table, store it in a varaible.

4. Use varaible to store the qvd.