Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Display data for next 4 months from the selected month?

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

1 Solution

Accepted Solutions
maxgro
Not applicable

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

108303 v2.jpg

9 Replies
Not applicable

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

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.

MK_QSL
Not applicable

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

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.

maxgro
Not applicable

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

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

Not applicable

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

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.

PMFeb 14Mar 14Apr 14May 14Jun 14Jul 14Aug 14Sep 14Oct 14Nov 14Dec 14Jan 15Feb 15
John Doe12335123.2117.6168401681684014040160152
John Doe200000000000160152
John Doe37216840168168401681684014040160152
John Doe400-52.875.675.6123.2117.6117.6123.2100.8123.2112106.4
John Doe53875.6105.6151.2168401681684014040160152
Not applicable

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

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

Not applicable

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

Please see in this post to my sample data.

SunilChauhan
Not applicable

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

Hi,

You could try using my sample application

try to build your Requirement base on it

Hope this helps

maxgro
Not applicable

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

108303 v2.jpg

Not applicable

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

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