topic Re: NECESITO AYUDA CON LA FUNCION SUM in Reporting Service & Alerting https://community.qlik.com/t5/Reporting-Service-Alerting/NECESITO-AYUDA-CON-LA-FUNCION-SUM/m-p/2439962#M964 <P>Two things</P> <P>1. check that your source data is valid and how it is formatted</P> <P>2. select the number representation on "Number' tab as shown below to ensure the pattern matches your data formatting expectations.</P> <P><IMG src="https://lithium-response-prod.s3.us-west-2.amazonaws.com/qlik.response.lithium.com/RESPONSEIMAGE/0b740025-52d6-492d-8e50-18d0a5ccc0c6.default.png" /></P> Wed, 10 Apr 2024 21:32:19 GMT Frank_S 2024-04-10T21:32:19Z NECESITO AYUDA CON LA FUNCION SUM https://community.qlik.com/t5/Reporting-Service-Alerting/NECESITO-AYUDA-CON-LA-FUNCION-SUM/m-p/2439955#M962 <P>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</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sacc_0-1712781141891.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/163847i8401B61F07346158/image-size/medium?v=v2&amp;px=400" role="button" title="sacc_0-1712781141891.png" alt="sacc_0-1712781141891.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sacc_1-1712781154138.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/163848i49B74F8F484E6D96/image-size/medium?v=v2&amp;px=400" role="button" title="sacc_1-1712781154138.png" alt="sacc_1-1712781154138.png" /></span></P> <P>eso es lo que me sale cuando me de beria salir&nbsp;<SPAN>9,584,291,70</SPAN></P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 10 Apr 2024 20:33:41 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/NECESITO-AYUDA-CON-LA-FUNCION-SUM/m-p/2439955#M962 sacc 2024-04-10T20:33:41Z Re: NECESITO AYUDA CON LA FUNCION SUM https://community.qlik.com/t5/Reporting-Service-Alerting/NECESITO-AYUDA-CON-LA-FUNCION-SUM/m-p/2439962#M964 <P>Two things</P> <P>1. check that your source data is valid and how it is formatted</P> <P>2. select the number representation on "Number' tab as shown below to ensure the pattern matches your data formatting expectations.</P> <P><IMG src="https://lithium-response-prod.s3.us-west-2.amazonaws.com/qlik.response.lithium.com/RESPONSEIMAGE/0b740025-52d6-492d-8e50-18d0a5ccc0c6.default.png" /></P> Wed, 10 Apr 2024 21:32:19 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/NECESITO-AYUDA-CON-LA-FUNCION-SUM/m-p/2439962#M964 Frank_S 2024-04-10T21:32:19Z Re: NECESITO AYUDA CON LA FUNCION SUM https://community.qlik.com/t5/Reporting-Service-Alerting/NECESITO-AYUDA-CON-LA-FUNCION-SUM/m-p/2440187#M966 <P>Thanks but its no the solution .I have the same result about my problem&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sacc_0-1712840333079.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/163886iE187D6EC2065FE60/image-size/medium?v=v2&amp;px=400" role="button" title="sacc_0-1712840333079.png" alt="sacc_0-1712840333079.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sacc_1-1712840342301.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/163887iC48D846E42167C30/image-size/medium?v=v2&amp;px=400" role="button" title="sacc_1-1712840342301.png" alt="sacc_1-1712840342301.png" /></span></P> <P>&nbsp;</P> Thu, 11 Apr 2024 13:03:31 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/NECESITO-AYUDA-CON-LA-FUNCION-SUM/m-p/2440187#M966 sacc 2024-04-11T13:03:31Z Re: NECESITO AYUDA CON LA FUNCION SUM https://community.qlik.com/t5/Reporting-Service-Alerting/NECESITO-AYUDA-CON-LA-FUNCION-SUM/m-p/2440238#M967 <P>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.</P> <P>Without seeing your QVW it is nearly impossible to provide a more helpful solution.</P> <P>So please use the attached file and modify the load script so it resembles the behavior in your QVW.</P> <P>Save it then share it here we can have a look at it and provide an update.</P> <P>kind regards...</P> Thu, 11 Apr 2024 14:16:13 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/NECESITO-AYUDA-CON-LA-FUNCION-SUM/m-p/2440238#M967 Frank_S 2024-04-11T14:16:13Z Re: NECESITO AYUDA CON LA FUNCION SUM https://community.qlik.com/t5/Reporting-Service-Alerting/NECESITO-AYUDA-CON-LA-FUNCION-SUM/m-p/2440250#M968 <DIV class="flex-1 overflow-hidden"> <DIV class="react-scroll-to-bottom--css-zesby-79elbk h-full"> <DIV class="react-scroll-to-bottom--css-zesby-1n7m0yu"> <DIV> <DIV class="flex flex-col text-sm pb-9"> <DIV class="w-full text-token-text-primary" dir="auto" data-testid="conversation-turn-21"> <DIV class="px-4 py-2 justify-center text-base md:gap-6 m-auto"> <DIV class="flex flex-1 text-base mx-auto gap-3 juice:gap-4 juice:md:gap-6 md:px-5 lg:px-1 xl:px-5 md:max-w-3xl lg:max-w-[40rem] xl:max-w-[48rem] group final-completion"> <DIV class="relative flex w-full flex-col agent-turn"> <DIV class="flex-col gap-1 md:gap-3"> <DIV class="flex flex-grow flex-col max-w-full"> <DIV class="min-h-[20px] text-message flex flex-col items-start gap-3 whitespace-pre-wrap break-words [.text-message+&amp;]:mt-5 overflow-x-auto" dir="auto" data-message-author-role="assistant" data-message-id="949a9313-d3ad-47d7-b31c-b29ad0493ec0"> <DIV class="markdown prose w-full break-words dark:prose-invert light"> <P>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)</P> </DIV> </DIV> </DIV> <DIV class="mt-1 flex gap-3 empty:hidden"> <DIV class="text-gray-400 flex self-end lg:self-center items-center justify-center lg:justify-start mt-0 -ml-1 h-7 gap-[2px] visible"><BUTTON class="flex items-center gap-1.5 rounded-md p-1 text-xs text-token-text-tertiary hover:text-token-text-primary md:invisible md:group-hover:visible md:group-[.final-completion]:visible"></BUTTON><BUTTON class="flex items-center gap-1.5 rounded-md p-1 text-xs text-token-text-tertiary hover:text-token-text-primary md:invisible md:group-hover:visible md:group-[.final-completion]:visible"></BUTTON> <DIV class="flex items-center gap-1.5 text-xs">&nbsp;</DIV> <DIV class="flex">&nbsp;</DIV> </DIV> </DIV> <DIV class="pr-2 lg:pr-0">&nbsp;</DIV> </DIV> <DIV class="absolute"> <DIV class="flex w-full gap-2 items-center justify-center">&nbsp;</DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> </DIV> <DIV class="w-full pt-2 md:pt-0 dark:border-white/20 md:border-transparent md:dark:border-transparent md:w-[calc(100%-.5rem)]"><FORM class="stretch mx-2 flex flex-row gap-3 last:mb-2 md:mx-4 md:last:mb-6 lg:mx-auto lg:max-w-2xl xl:max-w-3xl"> <DIV class="relative flex h-full flex-1 flex-col"> <DIV class="absolute bottom-full left-0 right-0">&nbsp;</DIV> <DIV class="flex w-full items-center">&nbsp;</DIV> </DIV> </FORM></DIV> Thu, 11 Apr 2024 14:25:05 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/NECESITO-AYUDA-CON-LA-FUNCION-SUM/m-p/2440250#M968 sacc 2024-04-11T14:25:05Z Re: NECESITO AYUDA CON LA FUNCION SUM https://community.qlik.com/t5/Reporting-Service-Alerting/NECESITO-AYUDA-CON-LA-FUNCION-SUM/m-p/2440313#M969 <P>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.</P> <P>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.</P> <P>At the moment, we are supporting May 2022 QlikView track and higher.</P> <P><A href="https://help.qlik.com/en-US/qlikview/May2022/Subsystems/QMC/Content/QV_QMC/QMC_System.htm" target="_blank">https://help.qlik.com/en-US/qlikview/May2022/Subsystems/QMC/Content/QV_QMC/QMC_System.htm</A></P> <P>Kind regards...</P> Thu, 11 Apr 2024 15:44:49 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/NECESITO-AYUDA-CON-LA-FUNCION-SUM/m-p/2440313#M969 Frank_S 2024-04-11T15:44:49Z Re: NECESITO AYUDA CON LA FUNCION SUM https://community.qlik.com/t5/Reporting-Service-Alerting/NECESITO-AYUDA-CON-LA-FUNCION-SUM/m-p/2440331#M971 <P><SPAN>How do I start a support case with the Qlik support team?</SPAN></P> Thu, 11 Apr 2024 16:30:23 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/NECESITO-AYUDA-CON-LA-FUNCION-SUM/m-p/2440331#M971 sacc 2024-04-11T16:30:23Z Re: NECESITO AYUDA CON LA FUNCION SUM https://community.qlik.com/t5/Reporting-Service-Alerting/NECESITO-AYUDA-CON-LA-FUNCION-SUM/m-p/2440350#M972 <P>Please follow this link and place your question into the chatbot popup on the bottom right hand side of the screen</P> <P><A href="https://community.qlik.com/t5/Support/ct-p/qlikSupport" target="_blank" rel="noopener">https://community.qlik.com/t5/Support/ct-p/qlikSupport</A></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Frank_S_0-1712857103097.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/163930i4E63925827E74D48/image-size/medium?v=v2&amp;px=400" role="button" title="Frank_S_0-1712857103097.png" alt="Frank_S_0-1712857103097.png" /></span></P> <P>&nbsp;</P> <P><BR />Give the chatbot:<BR />1. a clear description of the issue, QlikView version (12.x SRx)</P> <P>2. Expect results</P> <P>3. Actual results</P> <P>4. Explain if this has worked before or if this is the first time experiencing the issue.</P> <P>5. Make sure to share the link of this conversation with the support agent.</P> <P><A href="https://community.qlik.com/t5/Qlik-Reporting-Service/NECESITO-AYUDA-CON-LA-FUNCION-SUM/m-p/2440250#M968" target="_blank" rel="noopener">https://community.qlik.com/t5/Qlik-Reporting-Service/NECESITO-AYUDA-CON-LA-FUNCION-SUM/m-p/2440250#M968</A></P> <P>6. Then request to open a support case with the agent if needed.</P> <P>Kind regards...</P> <P>&nbsp;</P> Thu, 11 Apr 2024 17:39:52 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/NECESITO-AYUDA-CON-LA-FUNCION-SUM/m-p/2440350#M972 Frank_S 2024-04-11T17:39:52Z Re: NECESITO AYUDA CON LA FUNCION SUM https://community.qlik.com/t5/Reporting-Service-Alerting/NECESITO-AYUDA-CON-LA-FUNCION-SUM/m-p/2440361#M973 <P>Here is a video you can follow as well:<BR /><A href="https://community.qlik.com/t5/Video-Transcripts/Transcript-Opening-a-Support-Case-from-the-Qlik-Community/ta-p/1840694" target="_blank">https://community.qlik.com/t5/Video-Transcripts/Transcript-Opening-a-Support-Case-from-the-Qlik-Community/ta-p/1840694</A></P> <P>Kind regards...</P> Thu, 11 Apr 2024 17:53:37 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/NECESITO-AYUDA-CON-LA-FUNCION-SUM/m-p/2440361#M973 Frank_S 2024-04-11T17:53:37Z