Displaying data for last 13 month

[Anonymous]

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

[vinieme12]

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

[vinieme12]

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

[Anonymous]

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

[Anonymous]

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.

[vinieme12]

You don't need only here

[Anonymous]

Yes, it worked without Only(). Thank you

[Anonymous]

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)