Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

nimbojack
New Contributor

Merge two multi boxes

I have two multi boxes that have two values each. A list of subjects and the scores. I would like to be able to select a subject and a score from each multi box and have the result displayed in a table.

So  

MultiBox 1                             MultiBox 2

Maths 10                              Commerce 5

English 12                             Statistics 6

Physics 11                             English  4

Chemistry 10                         Maths 3

In the final table, i would like to see

Maths 10

Commerce 5

If these are the criteria i selected to filter on

9 Replies
OmarBenSalem
Esteemed Contributor

Re: Merge two multi boxes

You want to see

Maths 10 Commerce 5 in the same column in a table? is that so?

nimbojack
New Contributor

Re: Merge two multi boxes

Well, maths would in a column, and the score would be in another column

OmarBenSalem
Esteemed Contributor

Re: Merge two multi boxes

well then just create a simple table; and add your 2 dimensions as 2 columns?

nimbojack
New Contributor

Re: Merge two multi boxes

How would i filter with the multibox?

OmarBenSalem
Esteemed Contributor

Re: Merge two multi boxes

you click on math from your multiBox1 and in your table, you'll have math in a column and commerce in the second one

give it a try..

Re: Merge two multi boxes

A couple of questions.

- You said "multibox". Is this Qlik Sense or QlikView?

- Do the two boxes contain the same fields?

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

nimbojack
New Contributor

Re: Merge two multi boxes

QLikview.

Yes, two boxes contain two columns each. Which are the same. Box 1:

Subject, Score. Box 2. Subject, Score.

On Wed, Nov 29, 2017 at 7:20 PM, Rob Wunderlich <qcwebmaster@qlikview.com>

Re: Merge two multi boxes

So you want to do a comparative analysis between what you select in Box 1 vs what you select in Box 2?  For that you'll want to use Alternate States.  Read up on Alternate States in the help and take a look at examples available here on the forum.

-Rob

nimbojack
New Contributor

Re: Merge two multi boxes

I have read up on it. I want both values to be displayed in the same table.

Sort of like using qlikview as a reporting tool.

On Wed, Nov 29, 2017 at 8:59 PM, Rob Wunderlich <qcwebmaster@qlikview.com>

Community Browser