Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Rek
Contributor
Contributor

Issue in searching in a table with trigger in field

Hello community,

I have an issue searching in a table contains a trigger select in field: 

I have a straight table with many columns as dimensions and expressions. One dimension contains a trigger, when the user select it, another sheet is activated. In the same table expressions are with searchable option. 

When I try to search in field and press enter, the trigger is activated and I move the next sheet while I didn't select the field with trigger ! 

Something else strange, when I clear selections I move also to the next page ! 

Capture trigger.PNG

I attach an exemple also.

Thank you

 

4 Replies
zhadrakas
Specialist II
Specialist II

Hello,

i think it is working as expected. The problem is how you select the values.

1) While clicking on a specific amount in your table you will automatically select the dimension value -> and activate the trigger

2) same for your search field in Amount column

3) Your clear selection thing only activates the trigger if trigger field was selected before (like mentionied in 1 & 2)

Let me show you:

sample1:

click the yellow point in screenshot

1.png

this will select Type and Trigger Field (cause this are your dimensions)

2.png

sample2:

select >50 will select only your dimensions too.

3.png

4.png

Solution:

Create listboxes for each field. Or one multibox and test this.

I think you only want the listbox for amount. 

5.png

 

 

Rek
Contributor
Contributor
Author

Thank you for your answer, but I need to show values in table (because I don't have only 3 columns) and I need the trigger to be activated only when the user select in trigger column. 

Thanks 

Rek

zhadrakas
Specialist II
Specialist II

no problem. Create your table with all columns you need. Then create a listbox with Amount. You can do the same input there. But this will only select Amount field. This way you dont activate the trigger.

sunny_talwar

Not sure if this is a possibility, but may be create another field from Trigger_field like this

LOAD *,
	 Trigger_field as Non_Trigger_Field;
LOAD * INLINE [
    Trigger_field, Type, Amount
    1, A, 50
    2, B, 100
    3, C, 150
    4, D, 70
    5, E, 20
];

Now you can use this field in the table where you plan to search the expression and may be have another list box with the other field for selection which triggers you to another tab.