Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Create a Calendar based on selections in Listboxes

Hello Experts,

I have a typical issue and couldn't find any post in the community already answering this:

I need to create a calendar based on selections done in  3 Listboxes --> Code, Year and Month (this has a list of working and non-working days in the form of 0's and 1's).

An example:

Code               |Year   |Jan         |Feb           |Mar.................

01                   |2014   |011....111|00111...111|0011...11 ..............

01                   |2015   |010...110|011111..0   |01111..11..................

.

.

.

02.................................

.

.

.

03...................................

.

.

.

04.......................................

I have loaded this table of data(as above) pertaining to these fields--Code,Year and all the months as Fields (Jan,Feb ...Dec). Every month having the values in the form of 0's and 1's representing non working days(0's) and working days(1's). I need to create a table as an output which can show up by clicking a button (after selection made from Code,Year) and must contain

CodeYearMonthDateWorking/Non-Working Day
0120140101/01/20150
0120140102/01/20151
0120140103/01/20151

I have framed the question in the best of language I could hope to get some solution from the experts.

Thanks

2 Replies
Anil_Babu_Samineni

Would you able to provide sample data which demonstrates the output.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Not applicable
Author

Hi Anil,

This is the output required:

CodeYearMonthDateWorking/Non-Working Day
0120140101/01/20150
0120140102/01/20151
0120140103/01/20151