topic Re: LIST BOX Issue in QlikView

LIST BOX Issue

Thu, 18 Jul 2013 13:57:48 GMT

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

Re: LIST BOX Issue

CELAMBARASAN — Thu, 18 Jul 2013 14:05:11 GMT

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.

Re: LIST BOX Issue

Thu, 18 Jul 2013 14:13:53 GMT

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.

Re: LIST BOX Issue

mphekin12 — Thu, 18 Jul 2013 14:21:58 GMT

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.

Re: LIST BOX Issue

Thu, 18 Jul 2013 14:29:36 GMT

Hi ,

Thank you for your reply.

Yes . There are only two valyues in sourcesym.

Also it is customer requirement.

Thanks

Nirmal.

Re: LIST BOX Issue

CELAMBARASAN — Thu, 18 Jul 2013 14:37:22 GMT

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

Re: LIST BOX Issue

Thu, 18 Jul 2013 14:54:30 GMT

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.

Re: LIST BOX Issue

CELAMBARASAN — Thu, 18 Jul 2013 17:18:13 GMT

Hi,

It won't make any performance issues.

Regards,

Celambarasan