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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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