topic Re: ListBox Data Problem in QlikView

ListBox Data Problem

Tue, 14 Jun 2011 07:45:23 GMT

Hi,

Can any one help in this

I have attached the Xlsheet and qvw file along with this post.

I want like this

From the file You can found All are checkable

FieldName: FieldName: FieldName: FieldName:

A B M N

And For each

A: B: M: N:

A1 B1 M1 N1

A2 B2 M2 N2

A3 B3 M3 N3

I may select Individual A/B/M/N or Multi selection Like A,B/A,M/A,N or A,M,N/B,M,N Like that

From that if we select A,then the corresponding values May also possible to select as usually Individual or multi.

Now what my requirement is I want to display what ever i select from those listboxes values of A/B/M/N values and their MinValue,MaxValues should be displayed in either table box or Straight table.

Hope so, You understand my requirement.

first,Is it possible to do like that..

Thanks

Re: ListBox Data Problem

Anonymous — Tue, 14 Jun 2011 10:59:53 GMT

Hi There,

Take a look at the file, is this what you are looking for?

Dennis.

Re: ListBox Data Problem

Tue, 14 Jun 2011 11:27:44 GMT

Hi Dennis,

Thanks for you response,

Sorry to say this 'That i am not able to open your file because my system doesn't have full version'.

Can you please send the logic for that with your explanation.

Thanks.........

Re: ListBox Data Problem

Anonymous — Wed, 15 Jun 2011 06:38:17 GMT

No Problem,

What I did was create a straight table with "Fieldname" as a dimension

And used the following Expressions:

Min(MinValue)

and

Max(MaxValue)

Let me know if this is what you are looking for ok?

Dennis.

Re: ListBox Data Problem

Wed, 15 Jun 2011 07:20:36 GMT

Hi Dennis,

Sorry that is not the way I want.

From your Logic,

we are displaying only one of the selected fieldnames of A/B/M/N from that only single selection is happened of either A's values or B's Values or M's Values or N's Values in a straight table.

What actually i want is

I may select individual from A,B,M,N or multi select.

And with in those also i may select Multiple selections.

So, finally the straighttable contains all the data from the selections based on listboxes.

See what happened after applying your logic to my file in this attachmment.

If you anything regarding that please send me.

Thanks......

Re: ListBox Data Problem

Wed, 15 Jun 2011 07:26:35 GMT

Sorry Dennis,

I made a mistake in my file I have changed Fieldname as Fieldgroup and viceversa.

Even after Correcting that als I may not get exactly how i want.

from this I may select either one from A,B,M,N.

I need Multi selection from A,B,M,N from my file.

Sorry once again and thanks for your logic.

Can we do like that and please help me.

You now find the recent attachment of my file after changes.

Thanks....

Re: ListBox Data Problem

Anonymous — Wed, 15 Jun 2011 09:47:06 GMT

I see what you mean now.

I think the best way to do this is to make separeted field for A, B, M and N in your loading script.

Because what you now created (in a clever way I think) is actually still 1 field, so if you select something it will effect the other selections in that field.

Re: ListBox Data Problem

Anonymous — Wed, 15 Jun 2011 09:59:49 GMT

Forget my reply, this is not the answer for your problem.