CategoryName Value greater than I(Issue with Totalvalue and Error message)

[#1]

Hi Team,

I have 2 queries regarding the below requirement. I have implemented the logic correctly and even the values are getting displayed correctly in the Bar chart.

The below Bar Chart  displays you the  Category Name Values greater than Company -'I'. There are 2 facts -EScore(not dependent on any dimension) and SEScore(dependent on SecCode). The below Bar chart displays the Category Name value greater than Company-'I' and it is showing correctly. I have come across 2  issues mentioned below.

Issue 1 : Whenever the values are not present, it should display custom error message " Score for I> Competition for all Category Names" in the bar chart.

For e.g. : When you click on Product Score, it should display the error message-"Score for I>Competition for all Category Names"

Issue 2 : When I click on Overall score- values are present but the total is not getting displayed in the chart(Title of the chart).

Kindly help me out in resolving the above 2 issues. Please find the attached QVW.

Thanks & Regards,

Hari

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

[#3]

Thank you so much Gysbert....