topic Re: Column values into list in QlikView

Column values into list

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I'm hoping this isn't too difficult but I have two simple filters - Region and Country. By selecting the Region and Country, I would like the user to see which types of paper to print on (e.g. A3, A4, Flyer, Poster etc).

Here are my filters for selection:

So for example when selecting 'EMEA' and 'UK' the following appears - which shows only 3 types are needed.

Question - how do I show the output from a user selection as a simple list?

E.g. from the selection above, I just want a box which shows:

Flyer

A4 Paper

A3 Paper

Your help is really appreciated!

Mark

Re: Column values into list

lorenzoconforti — Mon, 15 Oct 2018 15:49:35 GMT

Maybe just create a textbox with something like this in it:

=if(not(IsNull(only(Flyer))),'Flyer') & chr(13) &

if(not(IsNull(only(A4 Paper))),'A4 Paper')

and so on

Re: Column values into list

vishsaggi — Mon, 15 Oct 2018 16:05:59 GMT

As Lorenzo suggested just try like below in your Text object as another option

= Flyer & Chr(13) &

[A4 Paper] & Chr(13) &

[A3 Paper]

Re: Column values into list

MarcoWedel — Mon, 15 Oct 2018 20:57:48 GMT

What if your selection leads to multiple rows in your table?