topic Re: Blocks in Qlik Automate

Blocks

Seancy — Wed, 09 Apr 2025 17:37:38 GMT

I have been trying to create an automation using the blocks and each time, and each way I attempt to, I run into a block that fails or doesn't work with the 1st block or what ever. I have been though the help files and the interwebs and still no success. Below is what I am trying to do and if someone could give me the blocks to use in order I would appreciate it as I have tried for hours LOL

Send a chart from a Qlik app to a specific email address.

This chart has PO#, Qty, Item, Email

Each email can appear on multiple lines if there are multiple PO's or Items.

I have tried getting the straight table, setting a list variable to get the email addresses, tried using a deduplicate List block on the emails to get a distinct email, this block doesn't do as it claims, then I was going to somehow loop though each email, make a selection on that email in the chart, then send out the report, and then on to the next email.

I have also tried building a report but then that gets limited on which blocks can be used.

Any assistance would be appreciated.

Thanks,

Re: Blocks

hakana — Wed, 09 Apr 2025 18:19:15 GMT

Maybe you could try this as a start:

With an app that has some table:

LOAD * INLINE [
   PO#, Qty, Item, Email 
   001, 100, Item 1, me@test.com
   002, 10, Item 2, you@test.com
   003, 20, Item 3, someoneelse@test.com
   004, 80, Item 4, me@test.com
];

And in the app create a Dimension (under master items) for the Email field

You should now be able to use the List Dimension values to loop over all (distinct) Emails

Re: Blocks

Seancy — Wed, 09 Apr 2025 18:47:50 GMT

Thanks for the reply. I tried that but the block will not list out the dimensions when I select the app id
[cid:b832e6eb-1817-4014-a006-10e1b4913e18]

I have saved, test run, refreshed, used a different block and still the same. The automations are very finicky, like they lose connection to the server so they cannot perform the functions needed. Saving, running, and using a new block tends to work, but not today....