Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Help with script and charts

Hello all,

I would like to know how am I able to sum all the data from chart, without the suppressed value at the bottom.

I would like to put that information in variable, and then to divide the each location to get the percentage.

Data is not correct this way because it is summing the suppressed values

7 Replies
Not applicable

Re: Help with script and charts

Please post your qvw. I believe its problem with your % problem.

Not applicable

Re: Help with script and charts

Expression is sum(Workfiles.Length)/1048576, and the % expression is [Size of Qvw in MB]/ TotalSizeOfQvw

where TotalSizeOfQvw is variable that gets data by trigger on open, and its expression is sum(Workfiles.Length)/1048576.

erivera10
Contributor

Re: Help with script and charts

Se necesita el qvw para ver el código que usas.

The qvw need to see the code you are using.

Best regards.

Not applicable

Re: Help with script and charts

I'm sorry, but there is some sensitive data in that qlikview application.

Is there a way to help me without it?

Best Regards

erivera10
Contributor

Re: Help with script and charts

It is very complicated because information on it that you want to solve is not known. How to solve a problem if information is unknown.

Best Regards

jaimeaguilar
Valued Contributor II

Re: Help with script and charts

Hi,

try this and then you can upload a scrambled sample of your qvw:

Preparing examples for Upload - Reduction and Data Scrambling

regards

Not applicable

Re: Re: Help with script and charts

Thanks for the info,

here is the application

Community Browser