Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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