article show field n from table Y in Member Articles

show field n from table Y

kristof_j — Wed, 21 Sep 2022 17:07:35 GMT

Years ago I saw an app that showed the first n fields. The list boxes had a place in the app and if you loaded different data, the list boxes would adapt with the current fields.

Maybe it was done with an excel which listed the fields. But still, how do you do this?

I want to load data in the same qvw but I don't want to change the list boxes every time. It's mostly for colleagues who don't have advanced QV-skills.

Re: show field n from table Y

mall1m — Sat, 14 Dec 2019 22:31:31 GMT

Add in your script these variables

/* Variables for custom listbox */
Set vField1 = ='['&subfield(concat(DISTINCT $Field,'|'),'|',1)&']'; // =$(vField1)
Set vField2 = ='['&subfield(concat(DISTINCT $Field,'|'),'|',2)&']'; // =$(vField2)
... and so on

And put the following expression in your listbox

=$(vField1)
=$(vField2)

... and so on

Re: show field n from table Y

Sue_Macaluso — Thu, 19 Dec 2019 20:52:08 GMT

@kristof_j Hi, This question is better suited in the discussion forum vs. a document forum. Unfortunately, I cannot move from a document to the discussion forum. Here is the link to QlikView discussions: https://community.qlik.com/t5/New-to-QlikView/bd-p/new-to-qlikview