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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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.