Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
sarasunagaram
Partner - Contributor II
Partner - Contributor II

Two columns as a single list box

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..Capture.PNG


Thanks in Advance

Muni nagaram

10 Replies
tresesco
MVP
MVP

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

Not applicable

could you please share ur application ..

sarasunagaram
Partner - Contributor II
Partner - Contributor II
Author

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

Thanks

tresesco
MVP
MVP

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

sarasunagaram
Partner - Contributor II
Partner - Contributor II
Author

Thanks Tresesco

But how to use these columns as a single listbox.

Thanks

Muni nagaram

tresesco
MVP
MVP

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

Anonymous
Not applicable

Hi,

See attached.

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

CustomMonth_WeekNo_filter.png

Hope this helps!

sarasunagaram
Partner - Contributor II
Partner - Contributor II
Author

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

tresesco
MVP
MVP

May be like this?

Capture.PNG