we know how to do it in Qlik View, ass conditional dimension,
based on the month selection single or multiple, onfly we need to populate the table data.
please help..
for eg in below data if I select month as Jan2016 to feb2016, then I need max month record in jan and feb for project A & B I need
on below data my result should be,
A, Feb2016
B,Feb2016
if nov2015 to dec2015
A, Dec2015
B,Nov2015 (as no dec 2015 data)
month selected may be 2 months or more. max month record shoul appear with remaining column on fly.. please help.
| ProjectID | ([Month]) | DN_TrendDate | x | Stage | total |
| A | Nov 2015 | 01-11-15 0:00 | - | - | 0 |
| A | Dec 2015 | 01-12-15 0:00 | - | - | 0 |
| A | Jan 2016 | 01-01-16 0:00 | 0 | 0 | 13 |
| A | Feb 2016 | 01-02-16 0:00 | 0 | 1 | 13 |
| A | Mar 2016 | 01-03-16 0:00 | 0 | 1 | 14 |
| A | Apr 2016 | 01-04-16 0:00 | 0 | 1 | 14 |
| A | May 2016 | 01-05-16 0:00 | 0 | 2 | 14 |
| B | Dec 2015 | 01-12-15 0:00 | - | - | 0 |
| B | Jan 2016 | 01-01-16 0:00 | - | 0 | 0 |
| B | Feb 2016 | 01-02-16 0:00 | 0 | 1 | 0 |
| B | Mar 2016 | 01-03-16 0:00 | 0 | 1 | 0 |
| B | Apr 2016 | 01-04-16 0:00 | 0 | 1 | 0 |
| B | May 2016 | 01-05-16 0:00 | 0 | 1 | 0 |
| B | Jun 2016 | 01-06-16 0:00 | 0 | 1 | 0 |
| B | Jul 2016 | 01-07-16 0:00 | 0 | 1 | 0 |
| B | Jan 2017 | 01-01-17 0:00 | 0 | 1 | 0 |
| B | Feb 2017 | 01-02-17 0:00 | 0 | 1 | 0 |
| B | Mar 2017 | 01-03-17 0:00 | 0 | 1 | 0 |
