Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ankitsrtva
Contributor
Contributor

Charts blanking out on Access Point however working fine on desktop version

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?

Labels (6)
1 Solution

Accepted Solutions
Anil_Babu_Samineni

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]))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

4 Replies
Anil_Babu_Samineni

Please provide the specification?

1) QV version

2) QV server version

3) Expression?

4) Error in Access point

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
ankitsrtva
Contributor
Contributor
Author

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. 

Anil_Babu_Samineni

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]))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
ankitsrtva
Contributor
Contributor
Author

This worked. Thanks a lot!