Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
mowens76
Contributor
Contributor

Column values into list

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:

1a.bmp

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

1b.bmp

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

1 Solution

Accepted Solutions
lorenzoconforti
Specialist II
Specialist II

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

View solution in original post

3 Replies
lorenzoconforti
Specialist II
Specialist II

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

View solution in original post

vishsaggi
Champion III
Champion III

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

= Flyer & Chr(13) &

   [A4 Paper] & Chr(13) &

   [A3 Paper]

MarcoWedel

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