Blocks

[Seancy]

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,

[hakana]

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

 

[Seancy]

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....