topic Re: Two columns as a single list box in QlikView

Two columns as a single list box

sarasunagaram — Thu, 09 Feb 2017 08:08:01 GMT

Hi All

Can anyone please help me to achieve the result shown here? These are the two different columns FisacalMonth,Weeknumber.

I wants to have the selection behavior of a list box with the header values..

Thanks in Advance

Muni nagaram

Re: Two columns as a single list box

tresB — Thu, 09 Feb 2017 08:53:17 GMT

If you have data like in screen shot above and excel output is your desired output, you may try like:

Corsstable (FiscalMonth, WeekNumber) Load

1 as dummy,

From <>;

Drop Field dummy;

If it is otherwise, you have to try The Generic Load

Re: Two columns as a single list box

Thu, 09 Feb 2017 09:02:29 GMT

could you please share ur application ..

Re: Two columns as a single list box

sarasunagaram — Thu, 09 Feb 2017 09:33:21 GMT

Excel file having original data but i want to show list box as the screen shot .

Thanks

Re: Two columns as a single list box

tresB — Thu, 09 Feb 2017 10:12:09 GMT

Try Like:

GenericLabel:

generic LOAD

Weeknumber as Key,

FisacalMonth,

Weeknumber

FROM [DATA.xlsx](ooxml, embedded labels, table is Sheet1);

CombinedGenericTable:

load Distinct Weeknumber as Key

from [DATA.xlsx](ooxml, embedded labels, table is Sheet1);

FOR i = NoOfTables()-1 to 0 STEP -1

LET vTable=TableName($(i));

IF WildMatch('$(vTable)', 'GenericLabel.*') THEN

LEFT JOIN ([CombinedGenericTable]) LOAD * RESIDENT [$(vTable)];

DROP TABLE [$(vTable)];

ENDIF

NEXT i

Re: Two columns as a single list box

sarasunagaram — Thu, 09 Feb 2017 10:19:37 GMT

Thanks Tresesco

But how to use these columns as a single listbox.

Thanks

Muni nagaram

Re: Two columns as a single list box

tresB — Thu, 09 Feb 2017 10:26:38 GMT

Well lets press 'Refresh' button. What is your real scenario? Please explain in detail.

Re: Two columns as a single list box

Anonymous — Thu, 09 Feb 2017 10:41:18 GMT

Hi,

See attached.

Modify to get a field associated with the calendar in your app

Hope this helps!

Re: Two columns as a single list box

sarasunagaram — Thu, 09 Feb 2017 10:48:25 GMT

Hi Tresesco

I have two fields weeknumber and month name (examole:P01-01,month and weeknumber) i want display two fields in a list box for making selections.

Thanks

Muni nagaram

Re: Two columns as a single list box

tresB — Thu, 09 Feb 2017 11:11:45 GMT

May be like this?

Re: Two columns as a single list box

sarasunagaram — Thu, 09 Feb 2017 11:56:40 GMT

Hi Tresesco

While making selections it is showing like below but it should not be

it should be like