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

chadsherk — Tue, 05 Jun 2012 20:35:38 GMT

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..

thank you in advance.

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

rwunderlich — Wed, 06 Jun 2012 00:19:03 GMT

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

types:

LOAD DISTINCT

'Square' as Type

RESIDENT data

WHERE B LIKE '*square*'

;

LOAD DISTINCT

'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

topic Re: help... How to create seperate column for user selection in QlikView

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

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