Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Suxel
Contributor III
Contributor III

Chart Subtitle to display dynamic MoM YoY percentage

Background:

I'm trying to display dynamic MoM YoY percentage in Chart Subtitle, which based on the latest month in the chart.

For example, the latest month is May.22, relevant MoM YoY percentage will display as shown in below image.

Suxel_1-1655880672695.png

Below is the expression for Product A,

='$(=$(LatestMonth))'
& ' (MoM: ' &

NuM(Sum({1}{<ProductCategory={"Product A*"},MonthYear={'$(=$(LatestMonth))'}>} [Transaction Volume]) /
Sum({1}{<ProductCategory={"Product A*"},MonthYear={'$(=$(LatestMonth))'}>} TrnVol_LastMonth) - 1, '0%')

& ' YoY: ' &
NuM(Sum({1}{<ProductCategory={"Product A*"},MonthYear={'$(=$(LatestMonth))'}>} [Transaction Volume]) /
Sum({1}{<ProductCategory={"Product A*"},MonthYear={'$(=$(LatestMonth))'}>} TrnVol_LastYear) - 1, '0%')
& ')'

 

Question:

How to make the expression to be responsive on below scenario,

1. when ProductCategory is filtered to Product B only, show nothing for Product A

2. when ProductCategory is filtered to Product A - Grade II, show only % relevant to Product A - Grade II but not the overall % for Product A

 

Labels (2)
0 Replies