topic Re: Pass the filter value in a loop in Qlik Sense automation in Qlik Automate

Pass the filter value in a loop in Qlik Sense automation

Ipsita2023 — Thu, 21 Mar 2024 05:07:01 GMT

Hi All,

My requirement is :

I have a field Division and it contains 5 different values

Division	Region
A	xxx
B	xxx
C	yyy
D	yyy
E	xxx

I want to pass only Those Divisions where region is xxx. Mean only need to pass A,B,E in a loop in Qlik sense automation.

I am not able to filter out those values in automation block.

Please help me here.

Thanks

Re: Pass the filter value in a loop in Qlik Sense automation

Shai_E — Thu, 21 Mar 2024 09:06:53 GMT

Hi @Ipsita2023

Would be hard to know without seeing the automation json and the run json log.

Best Regards

Re: Pass the filter value in a loop in Qlik Sense automation

PhilipZ — Thu, 21 Mar 2024 10:33:49 GMT

I solved this using a loop and condition block and replicated your list by adding the rows manually to a Variable.

The full solution looks like that:

For the loop, I choose the second column as inputs:

Or just input it as JSON (you will have to adapt the table name according to your input): {$.TestTable[*][1]}

The condition is an if clause, if the current item in loop equals "xxx":

For the output, use the current loop index as input for the row (first bracket [{$.loop.index}]) and output the value in the first column (second bracket: [0])

Running the application, I get the requested output:

Hope that helps

Philip

Re: Pass the filter value in a loop in Qlik Sense automation

poojask123 — Mon, 02 Dec 2024 10:28:11 GMT

Hi @Ipsita2023 If the solution provided here worked, then can you share your automation json plz. Im trying to do something similar, but the solution isnt working very well with me.

Attaching here my json. @PhilipZ Can you plz help figuring out what could be wrong .

Here's what I am trying to do - There are 2 fields Email & FilterType.

2 out of 7 values in the Email field are with FilterType "MLOnly". I need to filter out all the Email's that have a FilterType - MLOnly, my output should be only 2 values from the Email field

Re: Pass the filter value in a loop in Qlik Sense automation

salmankojar — Mon, 02 Dec 2024 10:27:38 GMT

Hi @poojask123 can you please explain your requirement once again? So that I can find the issue in your automation as per your requirement.

Re: Pass the filter value in a loop in Qlik Sense automation

poojask123 — Mon, 02 Dec 2024 12:30:36 GMT

Hi @salmankojar I have 2 columns like below (brought it into a table just to show you how they are related). I have to prepare an automation such that, all the E-mail's with FilterType MLOnly are passed into a loop. Once the E-mail values are filtered, I then need to prepare a content that will be shared to these filtered E-mails.

I am unable to filter the E-mails based on the FilterType value.

Automation JSON is attached

E-mail	FilterType
QlikView1@abc.com	MLOnly
QlikView2@abc.com	BGOnly
QlikView3@abc.com	BGROnly
QlikView4@abc.com	MLOnly
QlikView5@abc.com	MLROnly
QlikView6@abc.com	-
QlikView7@abc.com	ROnly

Re: Pass the filter value in a loop in Qlik Sense automation

salmankojar — Mon, 02 Dec 2024 13:10:51 GMT

Hi @poojask123 ,
i have created a straight table in Qlik app by creating table of your data using Inline script.In automaton i have used that straight table data to filter out your output recipient emails.

Re: Pass the filter value in a loop in Qlik Sense automation

poojask123 — Mon, 02 Dec 2024 13:59:15 GMT

Hey Thank you so much @salman . Din realize it was this simple 🙂

Re: Pass the filter value in a loop in Qlik Sense automation

DanielZandersQlik — Mon, 02 Dec 2024 15:15:30 GMT

You could just use the Filter List Block to get this List, so no need for extra condition in a loop.

Re: Pass the filter value in a loop in Qlik Sense automation

salmankojar — Tue, 03 Dec 2024 02:10:31 GMT

@poojask123 yea it is simple..just understand the different types of blocks and use them as per your requirements..!!

Re: Pass the filter value in a loop in Qlik Sense automation

QlikNAM — Thu, 13 Feb 2025 10:09:19 GMT

How about select value in field block and lock the field ... should resolve the issue