Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
MPkg
Contributor III
Contributor III

Add Field Selection one by one - Qlik automation

Hello,

I created Automation that generates report with two fields and one selection in each field.

- Field one:

Fruit:

Apple

Banana

- Field two:

Color:

Green

Red

Yellow

 

Fruit Color
Apple Green
Apple Red
Banana Yellow

 

I would like to make a selection now to the Apple, and loop through Color and add to separate sheet.

The problem is that if I select Apple from fruit, all colors get selected at once. 

 

How I can select colors one by one, that are only connected to Apple.

 

I made an automation for this:

MPkg_0-1695893229403.png

 

 

- Add Selection To Report: Select Apple from Fruit

- Lock Selections For Field: Fruit

- List Values Of Field: Color

- Add Sheet To Report 4: in each iteration create new sheet

- Add Selection To Report 2 : Color field

MPkg_1-1695892692507.png

 

The problem is that in each Sheet I get all 3 values selected: Green, Red, Yellow at once.

I want two sheets, one with Green, and one with Red color for Apple, but with List Values Of Field.

 

I am still learning, so I am sorry if it is simple.

Thanks.

Labels (1)
2 Replies
MPkg
Contributor III
Contributor III
Author

Solution to get value by values is by adding Add selection to Sheet.

MPkg_0-1695910766133.png

 

and determining Values as Q Text

MPkg_1-1695910792140.png

I still need to find out how to select only correct values for color (Green, Red) and not all three...

Andra
Partner - Contributor
Partner - Contributor

Kind of looking at same issue.
I  assume a Condition Block within the loop should solve it.