topic Re: Store different variable values in Qlik Application Automation in Qlik Automate

Store different variable values in Qlik Application Automation

OmuniBasav — Wed, 21 Dec 2022 13:40:18 GMT

Hi All,

I want to send KPIs data from Qlik to Slack. Hence I am storing KPI values in a different variables in Qlik Sense App, then I have created Qlik App Automation, where I am storing them in a different variables again and calling them in Slack Block Message.

But Only the First variable is getting stored, for the next variable it shows null in Automation, but in Qlik Sense app, I can see the calculated value. Below are the screenshots for your reference. Please help.

Re: Store different variable values in Qlik Application Automation

J_Lindberg — Wed, 21 Dec 2022 16:18:49 GMT

Hello @OmuniBasav, which variable are you fetching using the "Get Variable 2" block?

Re: Store different variable values in Qlik Application Automation

OmuniBasav — Wed, 21 Dec 2022 16:21:26 GMT

Hi @J_Lindberg , I'm fetching vAutoPickFail variable.

Re: Store different variable values in Qlik Application Automation

J_Lindberg — Wed, 21 Dec 2022 17:19:17 GMT

Thank you @OmuniBasav , what if you remove the Num() conversion, so that you only calculate the Sum? Then you could round the value in the variable by adding a formula such as: {round: {$.getExpressionValue}, 0}

Re: Store different variable values in Qlik Application Automation

OmuniBasav — Wed, 21 Dec 2022 17:55:39 GMT

@J_Lindberg Below snapshot shows chronological order of my output after making changes as per your suggestion.

I want Variable - message 1 to show in percentage like '20%'. Can you please let me know how do i do that?

Re: Store different variable values in Qlik Application Automation

J_Lindberg — Thu, 22 Dec 2022 08:50:39 GMT

@OmuniBasav In this case it seems as if you first want to round the value to one decimal then multiply this with 100 to get the percentage using formulas: {multiply: {round: {$.getExpressionValue}, 1}, 100}

Then add the percentage sign to the Slack message:

Re: Store different variable values in Qlik Application Automation

OmuniBasav — Thu, 22 Dec 2022 09:49:02 GMT

Hi @J_Lindberg , Thank you. Its now working. What I did is, first multiplied the value and then rounded it up, at the output gave % sign, just like you suggested.

{round:{multiply: {$.getExpressionValue2},100},2}

Thanks again. Below is the my output.