LAST THREE MONTH DATA FOR INACTIVE USER IN A STRAIGHT TABLE

manoranjan_d — Thu, 10 Nov 2016 13:31:09 GMT

i i want to show the username,USERID,FIRST NAME,LSTNAME data in straight table who are inactive(not logged) for past 3 months below is the data how to do this in the straight table?

USERNAME	LOGIN HISTORY	USERID	FIRST NAME	LSTNAME	USER TYPE
x1	1/1/2016	A	AA	BB	ACTIVE
x1	2/1/2016	A	AA	BB	INACTIVE
x1	3/1/2016	A	AA	BB	ACTIVE
x1	4/1/2016	A	AA	BB	INACTIVE
x1	5/1/2016	A	AA	BB	ACTIVE
x1	6/1/2016	A	AA	BB	INACTIVE
x1	7/1/2016	A	AA	BB	ACTIVE
x1	8/1/2016	A	AA	BB	INACTIVE
x1	9/1/2016	A	AA	BB	ACTIVE
x1	10/1/2016	A	AA	BB	INACTIVE
x1	11/1/2016	A	AA	BB	ACTIVE
x2	1/1/2016	BB	BBB	BBBB	INACTIVE
x2	2/1/2016	BB	BBB	BBBB	ACTIVE
x2	3/1/2016	BB	BBB	BBBB	ACTIVE
x2	4/1/2016	BB	BBB	BBBB	ACTIVE
x2	5/1/2016	BB	BBB	BBBB	ACTIVE
x2	6/1/2016	BB	BBB	BBBB	ACTIVE
x2	7/1/2016	BB	BBB	BBBB	INACTIVE
x2	8/1/2016	BB	BBB	BBBB	INACTIVE
x3	9/1/2016	CC	CCC	CCCC	ACTIVE
x3	10/1/2016	CC	CCC	CCCC	ACTIVE
x3	11/1/2016	CC	CCC	CCCC	INACTIVE
x3	1/1/2016	CC	CCC	CCCC	INACTIVE
x3	2/1/2016	CC	CCC	CCCC	ACTIVE
x3	3/1/2016	CC	CCC	CCCC	ACTIVE
x3	4/1/2016	CC	CCC	CCCC	INACTIVE

Re: LAST THREE MONTH DATA FOR INACTIVE USER IN A STRAIGHT TABLE

manoranjan_d — Fri, 11 Nov 2016 06:58:07 GMT

no reply

topic Re: LAST THREE MONTH DATA FOR INACTIVE USER IN A STRAIGHT TABLE in QlikView

LAST THREE MONTH DATA FOR INACTIVE USER IN A STRAIGHT TABLE

Re: LAST THREE MONTH DATA FOR INACTIVE USER IN A STRAIGHT TABLE