LIST BOX Issue

[#1]

Hi Team,

I am new to Qlikview and I need your hep in solving the below issue.

I have a table with the below structure.(picture given bleow)

My requiremnt : I need a listbox with the values BASYS,BERMUDA and 'Combined'.

When I select BASYS it should filter the BASYS records . When I select BERMUDA the data should be filtered for BERMUDA.

I am able to do it in Qlikview. But I need one more value(ie Combined) in list box .If I select this combined value , I should get data for both BERMUDA and BASYS.

I am not sure how to acheive the combined part. Can anyone of you please help me in this..

Thanks in advance,

Nirmal.

Thanks

SourceSym	Maket
Premium
BASYS	Yes	100
BERMUDA	Yes	101
BASYS	Yes	102
BERMUDA	Yes	103
BERMUDA	Yes	104
BASYS	Yes	105
BERMUDA	Yes	106
BASYS	Yes	107

[CELAMBARASAN]

Hi,

You need make another table for this one.

TransformedTable:

Load DISTINCT

     ModifiedSourceSym,

     SourceSym

Resident TableName;

Concatenate(TransformedTable)

Load

     'Combined' AS  ModifiedSourceSym,

     SourceSym

Resident TransformedTable;

Then use ModifiedSourceSym field in your list boxes.

Hope it helps

Celambarasan.

[#3]

Hi Celambrasan,

Thanks for your reply.

In this case , I will be getting the values in list boxt. But how the association will happen.

when I clik on Combined, both values should be selected . How to acheive that ?

Thanks

Nirmal.

[mphekin12]

Are BASYS and BERMUDA your only two values in SourceSym?  If so, you will get the combined value of these two SourceSyms but not making  a selection in your list box.  You really don't need a Combined value unless it is a requirement of your customer.

[#5]

Hi ,

Thank you for your reply.

Yes . There are only two valyues in sourcesym.

Also it is customer requirement.

Thanks

Nirmal.

[CELAMBARASAN · Accepted solution]

Hi,

I missed out one while typing

TransformedTable:

Load DISTINCT

     SourceSym AS ModifiedSourceSym,

     SourceSym

Resident TableName;

Concatenate(TransformedTable)

Load

     'Combined' AS  ModifiedSourceSym,

     SourceSym

Resident TransformedTable;

PFA

Regards,

Celambarasan

[#7]

Hi Celambrasan,

Yes it worked fine .. Thanks a lot for your reply.

One more question. Actually my table in having more than 1 million rows  and 260 columns.

Will this change make any performance issues ?

Thanks

Nirmal.

[CELAMBARASAN]

Hi,

It won't make any performance issues.

Regards,

Celambarasan