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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
richnorris
Creator II
Creator II

Turn fields into variables

Hi,

I have a requirement to read a QVD, then select certain fields to include, and certain fields to aggregate.

Then, on a reload with the variables selected, it should spit out a QVD with the selected fields aggregated at the chosen level.

The bit that I'm having trouble with, is generalising it such that any QVD loaded will have the requisite number of variables generated such that they can be selected.

Also, once I have the variables, is there a clean way to iterate through them? I don't want to have big nested if statements, nor lots of individual if statements.

Is such a thing possible?

0 Replies