Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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