topic Re: Display data for next 4 months from the selected month? in QlikView

Display data for next 4 months from the selected month?

Fri, 21 Feb 2014 22:44:35 GMT

Could you help on how to display Project Performance data for next 4 months from the selected months when data is laid out by month in Excel for Qlikview report?

I have about 10 program managers on x axis and I have their available capacity for each month.

I have months selection at the top. Let's see I select Feb 2014, then I want to show data for Feb, Mar, Apr, & May for each person. Each month can have diff color bar.

Thank you

Re: Display data for next 4 months from the selected month?

Sat, 22 Feb 2014 03:18:12 GMT

Hi Priti,

You can modify your current expression adding the following condition in an example:

sum({$<Date={"$(='>='&max({$} Date)&'<='& Date(AddMonth(max({$}Date),4)))"}>} [Project Performance])

AddMonth returns the Date that you are specifing as first parameter, and add or substract the numbers of months in second parameter.

Good luck and tell me if you have more questions.

Regards.

Re: Display data for next 4 months from the selected month?

MK_QSL — Sat, 22 Feb 2014 08:01:47 GMT

Hi Priti,

There are many ways to achieve this by Set Analysis but most of the times it happens that when anyone suggest some result which is working on own system but will not work in your one due to difference in Date, Month format.

If you could attach your apps with sample data, it would help to achieve your requirement easily.

Re: Display data for next 4 months from the selected month?

maxgro — Sat, 22 Feb 2014 22:47:02 GMT

I agree, there are many possibilities, one of them attached

Re: Display data for next 4 months from the selected month?

Sun, 23 Feb 2014 15:08:29 GMT

Here is my sample data. I want to have bar chart with People on x axis, and Capacity on y axis. But there should be 4 bars each with diff color for next 4 months from the month selected. I'm still not able to get to that. Please help.

PM	Feb 14	Mar 14	Apr 14	May 14	Jun 14	Jul 14	Aug 14	Sep 14	Oct 14	Nov 14	Dec 14	Jan 15	Feb 15
John Doe1	23	35	123.2	117.6	168	40	168	168	40	140	40	160	152
John Doe2	0	0	0	0	0	0	0	0	0	0	0	160	152
John Doe3	72	168	40	168	168	40	168	168	40	140	40	160	152
John Doe4	0	0	-52.8	75.6	75.6	123.2	117.6	117.6	123.2	100.8	123.2	112	106.4
John Doe5	38	75.6	105.6	151.2	168	40	168	168	40	140	40	160	152

Re: Display data for next 4 months from the selected month?

Sun, 23 Feb 2014 15:09:32 GMT

Thank you . Your formula worked to an extent because it gives me the capacity values only for the month selected. Not next 4 months.

Re: Display data for next 4 months from the selected month?

Sun, 23 Feb 2014 15:10:17 GMT

Please see in this post to my sample data.

Re: Re: Display data for next 4 months from the selected month?

SunilChauhan — Sun, 23 Feb 2014 15:20:40 GMT

Hi,

You could try using my sample application

try to build your Requirement base on it

Hope this helps

Re: Re: Display data for next 4 months from the selected month?

maxgro — Sun, 23 Feb 2014 16:57:22 GMT

Re: Display data for next 4 months from the selected month?

Thu, 27 Feb 2014 15:30:43 GMT

This was perfect, thank you! All my five stars go to you! Others also helped. Thank you all. It is working for me now. !!!!!!!!!!!