topic Re: Displaying data for last 13 month in QlikView

Displaying data for last 13 month

Anonymous — Sun, 12 Feb 2017 10:12:56 GMT

Hi,

I searched many times in the forum but I could not find the answer. Please advise if I'm using the wrong keywords.

I have two charts:

Guage chart: To present the SLA (Met vs. Breached) for last month only
Pivot chart: To present the SLA (Met vs. Breach) per month for the last 13 month

Sample data of the pivot table:

Month	SLA Met	SLA Breached
Jan-16	96%	4%
Feb-16	95%	5%
Mar-16	95%	5%
Apr-16	94%	6%

How can I achieve this on one sheet?

Thank you,

Ibrahim

Re: Different Filters on Different Objects

vinieme12 — Sun, 12 Feb 2017 12:26:01 GMT

hi,

please provide a dataset that best replicates your scenario

Here is link to resources for beginners that may be helpful in getting started

https://community.qlik.com/search.jspa?q=beginners&type=document

Re: Different Filters on Different Objects

vinieme12 — Sun, 12 Feb 2017 12:27:57 GMT

search for more content on Set analysis on Community and Youtube, below are some links

Beginners' Introduction to Set Analysis - Qlik Sense and QlikView - YouTube

Dates in Set Analysis

Re: Different Filters on Different Objects

Anonymous — Sun, 05 Mar 2017 08:29:26 GMT

Hi Vineeth,

Thank you! The Set Analysis is very powerful!

Unfortunately, I still could not figure out how to achieve the table above.

Allow me to elaborate, I want the table above to appear if I select in my filter "Jan-16", so automatically the preceding 13 months to appear too.

Thank you,

Ibrahim

Re: Displaying data for last 13 month

Anonymous — Wed, 29 Mar 2017 06:41:17 GMT

Here is the solution I found somewhere on the community and thought of sharing just in case someone can benefit from it

Count(TOTAL <CLOSE_TIMEMonthYear>{<CLOSE_TIMEMonthYear={'>=$(=date(only(AddMonths(CLOSE_TIMEMonthYear,-12)),'MMM-YYYY'))<=$(=date(only(CLOSE_TIMEMonthYear),'MMM-YYYY'))'},RESOLVER_GROUP=,MANAGER=,RESOLVED_BY=>}INCIDENT_ID)

The key was to use the Only() function and the range. Correct my description if I'm wrong, please.

Re: Displaying data for last 13 month

vinieme12 — Wed, 29 Mar 2017 07:07:48 GMT

You don't need only here

Re: Displaying data for last 13 month

Anonymous — Wed, 29 Mar 2017 08:15:43 GMT

Yes, it worked without Only(). Thank you

Re: Displaying data for last 13 month

Anonymous — Wed, 29 Mar 2017 08:17:39 GMT

Here is the revised solution just in case someone can benefit from it

Count(TOTAL <CLOSE_TIMEMonthYear>{<CLOSE_TIMEMonthYear={'>=$(=date(AddMonths(CLOSE_TIMEMonthYear,-12),'MMM-YYYY'))<=$(=date(CLOSE_TIMEMonthYear,'MMM-YYYY'))'},RESOLVER_GROUP=,MANAGER=,RESOLVED_BY=>}INCIDENT_ID)