Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Visibility of straight table based on condition?

Hi All,

I want to make a straight table visible only if a user provide input.

Ex:  I want to display employee information in straight table only if emp ID is been provided as input. what setting should be done? or what expression need to be used.Which is best way to achieve this?

I have a input box to get input and straight table to display.. I need to check with visibility?

Regards,

Prajna

1 Solution

Accepted Solutions
sudeepkm
Specialist III
Specialist III

I think there are two ways you can achieve it.

1. Straight table layout show/hide

     Assume that all your emp ids are available in a list box and end user can select any single empid and then the st table can be visible.

You can go to the St table properties > Layout tab > Show > conditional > getSelectedCount(empid)=1 (keep it one if you just want to show one emp info in this table) or you can keep it getSelectedCount(empid) >0 if you want to show multiple emp ids in the st table.

2. Field event trigger

Another way of doing it is to set a variable with a value whenever an end user selects a Emp id from the Emp ID field.

Field event trigger can be found under Settings > Document Properties > Triggers > Field event trigger.

Select the field Emp ID and then setup an action of setting a variable value. And use the variable value as Conditional Show logic in the St tables's layout.

View solution in original post

2 Replies
sudeepkm
Specialist III
Specialist III

I think there are two ways you can achieve it.

1. Straight table layout show/hide

     Assume that all your emp ids are available in a list box and end user can select any single empid and then the st table can be visible.

You can go to the St table properties > Layout tab > Show > conditional > getSelectedCount(empid)=1 (keep it one if you just want to show one emp info in this table) or you can keep it getSelectedCount(empid) >0 if you want to show multiple emp ids in the st table.

2. Field event trigger

Another way of doing it is to set a variable with a value whenever an end user selects a Emp id from the Emp ID field.

Field event trigger can be found under Settings > Document Properties > Triggers > Field event trigger.

Select the field Emp ID and then setup an action of setting a variable value. And use the variable value as Conditional Show logic in the St tables's layout.

Not applicable
Author

Thank you ..  First one served the purpose

Regards,

Prajna