topic Re: Same field, different selections?? in QlikView

Same field, different selections??

Mon, 05 Sep 2011 13:37:49 GMT

Hi,

I am working on an application, in which I need 2 listboxes with the same field. For example 'Fruit'.

So, in listbox1 a user may select Apple ; Pear ; Banana then I want another listbox, with the same field BUT kind of unlinked to listbox1. So that in the second listbox the user may select different fruits or one, for example : Orange

I need them unlinked because I want to show a chart, with 1 bar/symbol (expression) with the fruits selected in listbox1 and another bar/symbol with the other listbox (Orange) value selected.

I'm sure I've seen this done before, but not sure how to achieve it.

Any ideas?

Re: Same field, different selections??

its_anandrjs — Mon, 05 Sep 2011 13:42:23 GMT

Hi,

Load list box some thing like

For 1.

If( Fruits= 'Apple','Pear','Banana', Fruits)

For 2

If( Fruits= 'Orange', Fruits)

Please confirm you want to laod from single field or it is different.

Regards,

Anand

Same field, different selections??

Mon, 05 Sep 2011 13:46:08 GMT

Yes, it's 1 field called Fruit, but I want 2 different selections(listboxes) - With any number of fruits per listbox selected.

Re: Same field, different selections??

its_anandrjs — Mon, 05 Sep 2011 13:56:17 GMT

Hi,

Ok i understood for this load to list box

For 1.

=if (Wildmatch(Fruits, 'Apple' , 'Pear' , 'Banana' ), Fruits)

For 2.

=if (Wildmatch(Fruits, 'Orange' ), Fruits)

Regards,

Anand

Same field, different selections??

Mon, 05 Sep 2011 14:04:18 GMT

I think that's on the right track, but not exactly what I'm looking for.

I've attached the sample .qvw at the top...to refer to.

So, basically I have 2 listboxes. Then a chart.

I want 2 expressions in the chart, one will just show values pertaining to the fruits selected in Listbox1, then the other expression(bar) will show values relating to listbox2.

It's a bit tricky.

Same field, different selections??

Mon, 05 Sep 2011 14:06:05 GMT

I think this might be the solution : http://community.qlik.com/message/35086#35086

BUT I'm not sure what the last one is implying.

Same field, different selections??

swuehl — Mon, 05 Sep 2011 14:06:09 GMT

Hi beanz,

there are probably different kind of approaches for that. I could think of:

- using input boxes with variables and possible values prepulated and restricted by field fruits

- using multiple non linked fields created during load only for selection, like

LOAD Fruits as FruitSelect1

resident YOURFRUITTABLE;

LOAD Fruits as FruitSelect2

resident YOURFRUITTABLE;

In both cases, you might need to use something like used here:

http://community.qlik.com/message/146311#146311

e.g.

=Sum({$<Fruits={'$(=concat(FruitSelect1,chr(39)&','&chr(39)))'}>}Value)

to create your expression in the comapring chart.

Hope this helps,

Stefan

Re: Same field, different selections??

swuehl — Mon, 05 Sep 2011 14:12:52 GMT

Attached a demo of approach #2.

Regards,

Stefan

Re: Same field, different selections??

swuehl — Mon, 05 Sep 2011 14:30:09 GMT

In your cases something like

=Sum({$<Fruit= Fruit1>}Value)

seems to be really enough.

edit: new app

edited by swuehl

Re: Same field, different selections??

richnorris — Mon, 05 Sep 2011 14:30:19 GMT

Cant you just do:

tmpFruits:

LOAD

Fruits

FROM

fruits.qvd (qvd);

(Or, wherever you are getting your fruits from, sql database, whatever)

FinalFruits:

LOAD

Fruits AS Fruits1,

Fruits AS Fruits2

RESIDENT tmpFruits;

drop table tmpFruits;

then have a listbox showing 'Fruits1' and a listbox showing 'Fruits2', and then the table showing 'Fruits1' and 'Fruits2'

Same field, different selections??

Mon, 05 Sep 2011 15:34:47 GMT

Thanks for all of your help on this one!