topic Get Straight Table Data in Qlik Automate

Get Straight Table Data

samkadouh — Thu, 11 Jul 2024 17:19:50 GMT

The Get Straight Table Data block returns a processed JSON payload data from a Qlik Sense straight table. I am trying to store the data into a Variable block (type: Table), and I want to use this data as part of my selections for Generating Reports flow. How can I parse the data so that it is readable and usable in other block's inputs?

Re: Get Straight Table Data

salmankojar — Fri, 12 Jul 2024 07:02:53 GMT

Hi @samkadouh you can directly pass selections in Qlik App Straight table through automation using Qlik Cloud Services blocks like LIST VALUES IN A FIELD or SELECT FIELD VALUE as per your requirement.

Re: Get Straight Table Data

samkadouh — Fri, 12 Jul 2024 17:00:16 GMT

The problem is the following: I have 6 sheets I want to add to the report. But I want to add two selections simultaneously (eg. x1 and y1). I have 10 values for X, and each X has 5 Y's. So technically, each X has 30 sheets, 5 different selections for Y for the same X. I need to loop over the 6 sheets, grab 1 value for X and apply the first Y value on the 6 sheets, then apply the second Y value on the same 6 sheets for the same X. I also want to do this for the remaining 9 X values. Let me know if this makes sense.

6 Sheets (10 X selections and 5 Y selections) Each X has to have 30 sheets (same sheets just different Y selections)