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

NECESITO AYUDA CON LA FUNCION SUM

En mi funcion sum de una variable me esta dando un valor menos de lo que deberia en el script no le hago ninguna modificacion solo la mando a llamar de la base de datos

sacc_0-1712781141891.png

sacc_1-1712781154138.png

eso es lo que me sale cuando me de beria salir 9,584,291,70

 

 

Labels (4)
8 Replies
Frank_S
Support
Support

Two things

1. check that your source data is valid and how it is formatted

2. select the number representation on "Number' tab as shown below to ensure the pattern matches your data formatting expectations.

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
sacc
Contributor II
Contributor II
Author

Thanks but its no the solution .I have the same result about my problem 

sacc_0-1712840333079.pngsacc_1-1712840342301.png

 

Frank_S
Support
Support

Perhaps you have an 'always one selected' or value property used in your data or some kind of set analysis forcing this value in your output.

Without seeing your QVW it is nearly impossible to provide a more helpful solution.

So please use the attached file and modify the load script so it resembles the behavior in your QVW.

Save it then share it here we can have a look at it and provide an update.

kind regards...

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
sacc
Contributor II
Contributor II
Author

This is the script I am using, the field that is giving me an error is 'valor_activo', the truth is I am not doing anything to it, I just call it as it is, and this function is what I use in my simple table: SUM(valor_activo)

 
 
 
 
 
 
Frank_S
Support
Support

Since we are going to need a copy of your QVW and we will also know which version of QlikView you are running to determine if you are using a supported version or not., we will ask you to start a support case with the Qlik Support desk to continue the investigation.

If you are not running a supported version, you will likely need to upgrade in order to test if the issue persists in a currently supported version of QlikView. If so, then a defect can be issued therein.

At the moment, we are supporting May 2022 QlikView track and higher.

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/QMC/Content/QV_QMC/QMC_System.htm

Kind regards...

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
sacc
Contributor II
Contributor II
Author

How do I start a support case with the Qlik support team?

Frank_S
Support
Support

Please follow this link and place your question into the chatbot popup on the bottom right hand side of the screen

https://community.qlik.com/t5/Support/ct-p/qlikSupport

Frank_S_0-1712857103097.png

 


Give the chatbot:
1. a clear description of the issue, QlikView version (12.x SRx)

2. Expect results

3. Actual results

4. Explain if this has worked before or if this is the first time experiencing the issue.

5. Make sure to share the link of this conversation with the support agent.

https://community.qlik.com/t5/Qlik-Reporting-Service/NECESITO-AYUDA-CON-LA-FUNCION-SUM/m-p/2440250#M...

6. Then request to open a support case with the agent if needed.

Kind regards...

 

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Frank_S
Support
Support

Here is a video you can follow as well:
https://community.qlik.com/t5/Video-Transcripts/Transcript-Opening-a-Support-Case-from-the-Qlik-Comm...

Kind regards...

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!