Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Displaying data for last 13 month

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:

MonthSLA MetSLA Breached
Jan-1696%4%
Feb-1695%5%
Mar-1695%5%
Apr-1694%6%

How can I achieve this on one sheet?

Thank you,

Ibrahim

7 Replies
vinieme12
Champion III
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinieme12
Champion III
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Anonymous
Not applicable
Author

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
Not applicable
Author

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
Champion III
Champion III

You don't need only here

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Anonymous
Not applicable
Author

Yes, it worked without Only(). Thank you

Anonymous
Not applicable
Author

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)