Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
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 (3)
1 Reply
martyn_birzys
Creator
Creator

If I understand you correctly, you need to create a qvd for each year? If that's so, I'd use for each loop, something like:

FOR Each y in FieldValueList('Year')

STORE Material , Vendor,Plant , Year ,Price into 'lib://FolderConnection/myfile ' & '$(y)' & '.qvd'

NEXT y;