last three months data

manoranjan_d — Thu, 10 Nov 2016 07:51:47 GMT

Hi all,

I need a static chart which shd show,no of times user logged for Past 3 months

i given the dimension as user name and count(loginhistory)---> this is normal thing.

now i need the expression for the 3 months data for the login history and then the chart has to be static data.

example: this is November month, so i need only the last three moths data of login histoy for the user and that shd statc

static means any filter if i select,the cart should not change and 3 months data means , suppose if we are in december month means it shd show last three months data

i need expression to calculate the last three month data and how to make static for this requirement?

below is the data

USERNAME	LOGIN HISTORY
x1	1/1/2016
x1	2/1/2016
x1	3/1/2016
x1	4/1/2016
x1	5/1/2016
x1	6/1/2016
x1	7/1/2016
x1	8/1/2016
x1	9/1/2016
x1	10/1/2016
x1	11/1/2016
x2	1/1/2016
x2	2/1/2016
x2	3/1/2016
x2	4/1/2016
x2	5/1/2016
x2	6/1/2016
x2	7/1/2016
x2	8/1/2016
x3	9/1/2016
x3	10/1/2016
x3	11/1/2016
x3	1/1/2016
x3	2/1/2016
x3	3/1/2016
x3	4/1/2016

Re: last three months data

tresB — Thu, 10 Nov 2016 08:12:12 GMT

May be like:

Count({1<[LOGIN HISTORY]={'>=$(=MonthStart(Today(),-3)) <=$(=Date(Max({1}[LOGIN HISTORY])))'}>}[LOGIN HISTORY])

Re: last three months data

manoranjan_d — Thu, 10 Nov 2016 10:00:03 GMT

for static?

Re: last three months data

tresB — Thu, 10 Nov 2016 10:01:17 GMT

yes

topic last three months data in QlikView

last three months data

Re: last three months data

Re: last three months data

Re: last three months data