Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
@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:
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.
Hello @OmuniBasav, which variable are you fetching using the "Get Variable 2" block?
Hi @J_Lindberg , I'm fetching vAutoPickFail variable.
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}
@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?
@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:
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.