Create a Calendar based on selections in Listboxes

Wed, 25 Nov 2020 16:16:04 GMT

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

Code	Year	Month	Date	Working/Non-Working Day
01	2014	01	01/01/2015	0
01	2014	01	02/01/2015	1
01	2014	01	03/01/2015	1

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

Thanks

Re: Create a Calendar based on selections in Listboxes

Anil_Babu_Samineni — Fri, 14 Oct 2016 16:59:08 GMT

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

Re: Create a Calendar based on selections in Listboxes

Fri, 14 Oct 2016 21:19:05 GMT

Hi Anil,

This is the output required:

Code	Year	Month	Date	Working/Non-Working Day
01	2014	01	01/01/2015	0
01	2014	01	02/01/2015	1
01	2014	01	03/01/2015	1

topic Create a Calendar based on selections in Listboxes in QlikView

Create a Calendar based on selections in Listboxes

Re: Create a Calendar based on selections in Listboxes

Re: Create a Calendar based on selections in Listboxes