topic Re: Not Able to open document in aceesspoint in QlikView

Not Able to open document in aceesspoint

deepakqlikview_123 — Thu, 15 May 2014 10:04:45 GMT

Hi All,

Please find attahed screenshot.

When I am trying to open document in accesspoint it is not showing chart and only loading.

Can you please suggest on this.

Thanks ,

Deepak

Re: Not Able to open document in aceesspoint

nizamsha — Thu, 15 May 2014 10:07:21 GMT

what the chart object is telling out of object memory is that its showing

Re: Not Able to open document in aceesspoint

deepakqlikview_123 — Thu, 15 May 2014 10:09:14 GMT

Hi Nizam,

Actually those are bar charts.

Thanks

Re: Not Able to open document in aceesspoint

nizamsha — Thu, 15 May 2014 10:10:44 GMT

can u post the qvw so i can have a look

Re: Not Able to open document in aceesspoint

deepakqlikview_123 — Thu, 15 May 2014 10:14:28 GMT

Actually in QVW it is opeining fine but in accesspoint when I am opening same it gives problem.

Thanks

Re: Not Able to open document in aceesspoint

Peter_Cammaert — Thu, 15 May 2014 10:15:18 GMT

Are you sure the document is correct and does work outside of the accesspoint? Try for example to open the document in QlikView Desktop with the same amount of data and check how long it takes to display the objects in question.

Re: Not Able to open document in aceesspoint

deepakqlikview_123 — Thu, 15 May 2014 10:17:51 GMT

In Qlikview desktop it is taking around 20 seconds to open document.

Re: Not Able to open document in aceesspoint

nizamsha — Thu, 15 May 2014 10:19:30 GMT

have u wrote lof of if condition in that chart

Re: Not Able to open document in aceesspoint

deepakqlikview_123 — Thu, 15 May 2014 10:27:55 GMT

Hi Nizam,

Expression that I have used is as per below,

dual

(count(distinct EnquiryID)/1000 & ' (' & num((count(distinct EnquiryID)/count(distinct total EnquiryID)), '0.00%') & ')', count(distinct EnquiryID)

For first chart

and

dual

(count(distinct EnquiryID)/1000 & ' (' & num((count(distinct EnquiryID)/count(distinct total EnquiryID)), '0.00%') & ')', count(distinct EnquiryID)
)

For second chart.

Thanks,

Re: Not Able to open document in aceesspoint

nizamsha — Thu, 15 May 2014 10:29:20 GMT

so chart expression is the problem may i know ur dimension and ur expression

if chart take long time to open mean in dimension u might have used the aggr or in ur expression u have written lot of if condition these r the thing it will slow the chart performance if its not mean

create a new chart using the same dimension and expression and check

Re: Not Able to open document in aceesspoint

nizamsha — Thu, 15 May 2014 10:49:47 GMT

Try in ur expression

=Dual(sum(TotalPrice)/1000 & '('& num(sum(TotalPrice)/sum(TOTAL TotalPrice),'#,##.00%' & ')'

),Sum(TotalPrice))

Re: Not Able to open document in aceesspoint

nizamsha — Thu, 15 May 2014 10:51:49 GMT

=dual( num(count(distinct EnquiryID)/1000 ,'#,##0')& ' (' & num(count(distinct EnquiryID)/count(distinct total EnquiryID), '0.00%') & ')', count(distinct EnquiryID))