Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
chadsherk
Contributor
Contributor

help... How to create seperate column for user selection

Please help.....   I have rows of data that include part number as one field and shape as another  field.  The shape can be three options and is entered in the data sheet as either Square, rectangle, or "square and rectangle". How can I have the user click on square and have it pull up all parts with the discription of  either square or "square and rectangle".   and same for rectangle?

the scren shot shows a very small set of the data, but what I need to happen is to allow the  user to choose square, and have it pull up part numbers, 44444, 55555, and 22222.

I'm guessing I may need to create a seperate column for this, but am uncertain how to do that..

sr.PNG

thank you in advance. 

1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Assume your table with the A B columns is named "data".

types:

LOAD DISTINCT

          B,

          'Square' as Type

RESIDENT data

WHERE B LIKE '*square*'

;

LOAD DISTINCT

          B,

          'Rectangle' as Type

RESIDENT data

WHERE B LIKE '*rect*'

;

The second LOAD is not necessary if you don't need to set a type for Rectangle as well.

-Rob

http://robwunderlich.com