Discussion Board for collaboration related to QlikView App Development.
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
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,
Drop Field dummy;
If it is otherwise, you have to try The Generic Load
could you please share ur application ..
Excel file having original data but i want to show list box as the screen shot .
Weeknumber as Key,
FROM [DATA.xlsx](ooxml, embedded labels, table is Sheet1);
load Distinct Weeknumber as Key
from [DATA.xlsx](ooxml, embedded labels, table is Sheet1);
FOR i = NoOfTables()-1 to 0 STEP -1
IF WildMatch('$(vTable)', 'GenericLabel.*') THEN
LEFT JOIN ([CombinedGenericTable]) LOAD * RESIDENT [$(vTable)];
DROP TABLE [$(vTable)];
But how to use these columns as a single listbox.
Well lets press 'Refresh' button. What is your real scenario? Please explain in detail.
Modify to get a field associated with the calendar in your app
Hope this helps!
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.
May be like this?