Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
random_user_3869
Partner - Creator III
Partner - Creator III

Condition block within qlik app autoomation

Hello everyone,

 

I face an issue regarding condition block.

lessassy_3869_1-1662649770622.png

 

Basically i create a loop that generate a report for each new item.

In my condition block parameter:

The first parameter is : List of value : (which changes for every loop).

The second parameter is value from a straight table.

The issue is that let's say :

loop i = 1, IF ( Cars (value 1) = Cars (first column from straight table) then true 

loop i = 2, IF ( boat (value 2) = Cars (first column from straight table remains. It should check all the value) then false.

the issue is that when i >1 the "Get Straight Table Data 2 > Item > Mail Representant" remain at line 1.

Should i do a loop ? I don't know how to proceed.

Thanks 

 

Labels (1)
  • SaaS

4 Replies
brevels
Contributor II
Contributor II

I'm pretty sure you'll need a loop. I did something similar with a SharePoint list to update and insert into that list based on a condition. Hope this helps!

brevels_0-1662651488855.png

 

PietMichielRappelet
Former Employee
Former Employee

Hi

There are some items that do not seem to be implemented correctly: 

  •  your condition will never evaluate to true as you are checking if a list (QTEXT of all list values) equals to another list. 
  • You are not in a loop while you are using 'exit' loop

From what you are sharing, I believe you could use 2 loops or try using a lookup block and check if you have found the result you want (lookup in loop + if output of that block is not empty) 

Hope this helps. 

Kind regards, 

random_user_3869
Partner - Creator III
Partner - Creator III
Author

Thanks both of you @PietMichielRappelet  @brevels .

I still have one more issue.

I face some memry issue...

The thing is each pdf is 24MB.

once the second report is send i face the issue with memory.

Before i put another loop at the end of my workflow

lessassy_3869_0-1662712464674.png

 

but maybe i have to put it here :

lessassy_3869_1-1662712493017.png

 

But i still face an issue.

Thanks

random_user_3869
Partner - Creator III
Partner - Creator III
Author

The issue is the following one 

lessassy_3869_2-1662714284940.png

I attached the json file to it.

Maybe there is a way to optimize my workflow so that i don't have this issue.

Basically this flow is a test.

Maybe the loop at the end is not at the right place.

I want to try to avoid memory issue but i don't know how