I have a template I am creating in Qlikview. One tab will be called "filters" and I want to list out all possible fields in listboxes. (normally, I would right click select fields, highlight all and add them to the dashboard)
Since this will be a template, I would like to create listboxes under variable names and set those variables to fields in the edit script, so that once those variables are defined, the listboxes will show those field names and the data to select from.
Currently I have this script which I used from another post. However, in my listbox, I just see one paid amount (I know there are at least 800 different amounts) and the title of my listbox is one amount as well.
SQL Select top 1000 *
Load DISTINCT( paid_amount) as FieldA
I would like the edit script to have my loaded table and then another load that renames all of the fields- for example