Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

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
Highlighted
Champion II
Champion II

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

Highlighted
Champion II
Champion II

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

Highlighted
Contributor III
Contributor III

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

Highlighted
Contributor III
Contributor III

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.

Highlighted
Champion II
Champion II

You don't need only here

Highlighted
Contributor III
Contributor III

Yes, it worked without Only(). Thank you

Highlighted
Contributor III
Contributor III

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)