topic Re: Multibox ( Positive and negative) in QlikView

Multibox ( Positive and negative)

Mon, 15 Jun 2015 13:58:49 GMT

Hi, i need help for this:

I have this table, and i need to create a multibox, with 2 values ( 1. Selecting the posives ,2. Selecting the negatives)

Is this posible?

	Num	Num PY	Delta	Delta Pax %
a	685	738	-53	-7,2%
b	364	347	17	4,9%
c	253	302	-49	-16,2%
d	234	224	10	4,5%
e	196	153	43	28,1%
f	157	107	50	46,7%
Total	2.490	2.567	-77	-3,0%

Thanks

Re: Multibox ( Positive and negative)

giakoum — Mon, 15 Jun 2015 14:00:59 GMT

yes if you create an expression :

Re: Multibox ( Positive and negative)

Mon, 15 Jun 2015 14:08:02 GMT

Hi,

You can put two expressions in different Mutli-box's like

If delta < 0 for negative values

and

If delta >0 for positive values

Regards,

Re: Multibox ( Positive and negative)

morganaaron — Mon, 15 Jun 2015 14:37:01 GMT

If you want it as one selection, create an expression as suggested and write:

If(Delta >= 0, 'Positive', 'Negative')

Which should give one selection of either positive or negative that will filter your delta values.

If you want them as separate drop down selections, you could have the actual values by writing:

If(Delta >= 0, Delta) and If(Delta<0, Delta) as two expressions.

Re: Multibox ( Positive and negative)

Mon, 15 Jun 2015 14:40:19 GMT

The problem is that this table box has a Dimension, so if i put in a separte object the multibox as positive and negative, this does not work

Thanks

Re: Multibox ( Positive and negative)

morganaaron — Tue, 16 Jun 2015 07:19:54 GMT

A table box is a complete list of all data related to the fields you enter, so this shouldn't stop it from working.

Even if you had a straight table chart and had a dimension, it would still work. What's the exact problem you're facing? Can you post an example? Because any of the options above should work unless your delta field isn't an actual field and is a calculation of another value?