topic Multibox Compare two column in QlikView

Multibox Compare two column

Wed, 19 Nov 2014 00:47:44 GMT

Dear all,

I need a multibox when user select a order #, the qlikview will compare two column named order1 and order2. If the selected number exist in either 1 column then show the result in straight table.

To display in straight table no issue. My question is how do i compare two column using the multibox. Thank you

Re: Multibox Compare two column

JonnyPoole — Wed, 19 Nov 2014 00:59:06 GMT

I'm not sure what your data model is but if you have this data structure:

Order1s:

Load

Order1 as OrderNum,

Order1

from <>

Order2s:

Load

Order2 as OrderNum,

Order2

from <>

Then OrderNum can be what the user selects, and it will show in white (in the respective drop downs of each field in the multibox) in BOTH Order1 and Order2 any values that are the same

Re: Multibox Compare two column

Wed, 19 Nov 2014 01:11:39 GMT

for example below is my database

custno

custname

order1

order2

order1 and order2 is the product and repeatable for different customer. Then i want a qlikview compare input from multibox, for example, if the selection is 'ABC' then qlikview will retrieve record where order1 or order 2 contains the 'ABC'

Re: Re: Multibox Compare two column

JonnyPoole — Wed, 19 Nov 2014 01:54:39 GMT

Take a look at the attached and see if its near what you are looking for...

Re: Re: Multibox Compare two column

Wed, 19 Nov 2014 02:12:57 GMT

ok. just see u example. yup. this sample create another table successfully. but how do i join that two table together.

Based on your order.

What i want is i need a straight table to display the sheet1 records but your multibox is based on the resident data you created. I need to join the ordernumber to the main table right?

Re: Re: Multibox Compare two column

Wed, 19 Nov 2014 02:22:00 GMT

to explain more on what i wanted. i will use your data to explain.

if i choose 'ABC' then i want row 1,3,4 to be displayed

if i choose 'DEF' then i want row 1,2 to be displayed

Re: Re: Re: Multibox Compare two column

JonnyPoole — Wed, 19 Nov 2014 03:21:30 GMT

Here is an updated example

Re: Re: Re: Multibox Compare two column

Wed, 19 Nov 2014 03:26:55 GMT

The content of attached file seems different from the your screenshot. maybe the wrong file uploaded?

Re: Multibox Compare two column

JonnyPoole — Wed, 19 Nov 2014 03:29:05 GMT

oops ! 2nd time tonight I reattached the actual sample to the post above.

Re: Multibox Compare two column

Wed, 19 Nov 2014 03:39:07 GMT

The thing works. But one question, can we use multibox instead of using listbox?

Re: Multibox Compare two column

JonnyPoole — Wed, 19 Nov 2014 03:51:14 GMT

You can replace the OrderNum list box with a multibox showing the same field but ...

Are you asking if you would want to choose values from Order1 and Order2 in a multibox and then show the records that have an Order1 OR an Order2 equal to the Order1 value and the same for the value selected in Order2 ?