topic Re: Show Latest Month Data in QlikView

Show Latest Month Data

ashishpalkar — Wed, 24 Jun 2015 19:33:57 GMT

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.

Re: Show Latest Month Data

sunny_talwar — Wed, 24 Jun 2015 19:44:29 GMT

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

Re: Show Latest Month Data

MK_QSL — Wed, 24 Jun 2015 19:45:42 GMT

Use Calculated Dimension in your Application..

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

Re: Show Latest Month Data

ashishpalkar — Wed, 24 Jun 2015 19:48:05 GMT

Thanks

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

Re: Show Latest Month Data

ashishpalkar — Wed, 24 Jun 2015 19:48:39 GMT

I want to show this information on Graph.

Re: Show Latest Month Data

MK_QSL — Wed, 24 Jun 2015 19:54:51 GMT

Dimension

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

Project

Expression

COUNT(Distinct Associate)

COUNT(Associate)

Re: Show Latest Month Data

sunny_talwar — Wed, 24 Jun 2015 19:57:13 GMT

This?

Re: Show Latest Month Data

ashishpalkar — Wed, 24 Jun 2015 20:06:25 GMT

Yes, this kind of output on graph.

Re: Show Latest Month Data

sunny_talwar — Wed, 24 Jun 2015 20:09:16 GMT

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

Re: Show Latest Month Data

ashishpalkar — Wed, 24 Jun 2015 20:11:14 GMT

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

Re: Show Latest Month Data

sunny_talwar — Wed, 24 Jun 2015 20:12:27 GMT

It is attached with my previous post. Open this link: Re: Show Latest Month Data

Best,

Sunny

Re: Show Latest Month Data

ashishpalkar — Wed, 24 Jun 2015 20:17:54 GMT

Thanks again.

Re: Show Latest Month Data

sunny_talwar — Wed, 24 Jun 2015 20:19:28 GMT

No problem

I would ask you to mark correct/helpful answers to close the thread if the problem is resolved

Best,

Sunny

Re: Show Latest Month Data

ashishpalkar — Wed, 24 Jun 2015 20:27:55 GMT

One more twist in this, if the current month is June , it should only show June data. If there is no data in June it should display message as No data for June.

Re: Show Latest Month Data

sunny_talwar — Wed, 24 Jun 2015 20:30:22 GMT

How did you determine if you want to see June? Is it always going to be June data you would want to see??

Re: Show Latest Month Data

ashishpalkar — Wed, 24 Jun 2015 20:32:35 GMT

The current month is June and we have data for May. In such situation it should only show June Data and show message "No Data available".

Re: Show Latest Month Data

sunny_talwar — Wed, 24 Jun 2015 20:36:29 GMT

Please find attached

Expression:=Count({<Date = {"$(='>=' & Date(MonthStart(Today())))"}>}Associate)