Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We have a bar chart which works perfectly fine on desktop version. However, on access point, it is blanking out and showing an error message. We have only used a single expression in the chart which is working on the desktop version. Can anyone help us figure out what might be the issue?
What is the definition for this variable "vMATPF"?
And, One correction technically {I can understand, This is working in desktop not on access point}
=(sum({<$(vMATPF)={"C"}>}[Monthly Sales])+ sum({<$(vMATPF)={'C'}>}[Monthly Competitor Sales]))/
(sum(total<[Month'Year]>{<$(vMATPF)={"C"}>}[Monthly Sales]) + sum(total<[Month'Year]>{<$(vMATPF)={'C'}>}[Monthly Competitor Sales]))
Please provide the specification?
1) QV version
2) QV server version
3) Expression?
4) Error in Access point
QV Version: 12.10
QV Access Point Version: 12.4
Expression:
=(sum({<$(vMATPF)={"C"}>}[Monthly Sales])+ sum({<$(vMATPF)={'C'}>}[Monthly Competitor Sales]))/
(sum(total<Month'Year>{<$(vMATPF)={"C"}>}[Monthly Sales]) + sum(total<Month'Year>{<$(vMATPF)={'C'}>}[Monthly Competitor Sales]))
Error in Access Point: No data to display
I want to highlight that data is displaying properly in desktop version and the error in only noticeable on access point.
What is the definition for this variable "vMATPF"?
And, One correction technically {I can understand, This is working in desktop not on access point}
=(sum({<$(vMATPF)={"C"}>}[Monthly Sales])+ sum({<$(vMATPF)={'C'}>}[Monthly Competitor Sales]))/
(sum(total<[Month'Year]>{<$(vMATPF)={"C"}>}[Monthly Sales]) + sum(total<[Month'Year]>{<$(vMATPF)={'C'}>}[Monthly Competitor Sales]))
This worked. Thanks a lot!