Show Latest Month Data

[ashishpalkar]

Hi There

I have below requirement, where I want to show latest month data from given set of data, From below example I want to show only May Data in the graph / Table by default without selecting any parameters on the QV application.

Date	Project	Associate
1/1/2015	ABC	1
1/2/2015	ABC	2
1/3/2015	ABC	3
1/4/2015	ABC	4
1/5/2015	ABC	5
1/6/2015	ABC	6
1/7/2015	XYZ	7
1/8/2015	XYZ	8
1/9/2015	XYZ	9
1/10/2015	XYZ	10
1/11/2015	XYZ	11
1/12/2015	XYZ	12
2/1/2015	ABC	1
2/2/2015	ABC	2
2/3/2015	ABC	3
2/4/2015	ABC	4
2/5/2015	ABC	5
2/6/2015	ABC	6
2/7/2015	XYZ	7
2/8/2015	XYZ	8
2/9/2015	XYZ	9
2/10/2015	XYZ	10
2/11/2015	XYZ	11
2/12/2015	XYZ	12
5/1/2015	ABC	1
5/2/2015	ABC	2
5/3/2015	ABC	3
5/4/2015	ABC	4
5/5/2015	ABC	5
5/7/2015	XYZ	7
5/8/2015	XYZ	8
5/10/2015	XYZ	10
5/11/2015	XYZ	11

Thanks in advance.

[sunny_talwar]

Is this what you want?

Script:

Table:

LOAD Date,

    Project,

    Associate

FROM

[https://community.qlik.com/thread/169856]

(html, codepage is 1252, embedded labels, table is @1);

Dimension: Date, Project

Expression: =Only({<Date = {"$(='>=' & Date(AddMonths(Max(Date),-1)))"}>}Associate)

Best,

Sunny

[MK_QSL]

Use Calculated Dimension in your Application..

=Date(IF(Date>=MonthStart(Today()) and Date<=MonthEnd(Today()), Date))

[ashishpalkar]

Thanks

I want to count Number of associates for the months / project. 

[ashishpalkar]

I want to show this information on Graph.

[MK_QSL]

Dimension

=Date(IF(Date>=MonthStart(Today()) and Date<=MonthEnd(Today()), Date))

Project

Expression

COUNT(Distinct Associate)

or

COUNT(Associate)

[sunny_talwar]

This?

[ashishpalkar]

Yes, this kind of output on graph.

[sunny_talwar]

Convert it into a bar graph or line chart according to your need !:

[ashishpalkar]

Thanks , this is exactly what I am looking for.  Can you please send me QV file?