Need help - table query, based on condition show in table - Qliksense

[vinay_hg]

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

[vinay_hg]

need help..