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: 
Anonymous
Not applicable

Qlik sense User input interface

Hello,

I am new to Qlik sense and was working to create a dashboard which will take user input and filter the data according to User input from table.

For example - I have Employee table with 10 different columns in it and one of the Column is Employee Location. I want a Dashboard with User input field of Employee Location and data in table will be filter based on what Employee location user entered into given User input field.

I have an extension for input variable and have created a variable name vEmpLoc and tried to have some syntax to filter employee table with given User location as input. But it is not working.

Any help in this regard will be greatly appreciated!

Thanks in Advance!

9 Replies
DavidŠtorek
Creator III
Creator III

Hi,

maybe it is stupid question, bud why you don't use simple filter pane? You eliminate user typos and don't have tu build any expression.

ramkrishna86
Creator II
Creator II

Do created reference of input variable and employee table?

kkkumar82
Specialist III
Specialist III

can you share any sample app with the extension name you are using

kkkumar82
Specialist III
Specialist III

one more question what if user didn't give any value in the inputbox

DavidŠtorek
Creator III
Creator III

Sorry I don't understand what do you mean with this?

Anonymous
Not applicable
Author

Wants to make a dashboard which would be user interactive. am planning to have more such fields for data filter like Date range etc.

Anonymous
Not applicable
Author

I tried to create reference but it seems its not working and looking help on it. Any Pointers?

Anonymous
Not applicable
Author

May be don't filter anything or don't show any record. Anything should be fine.

DavidŠtorek
Creator III
Creator III

I understand that point and still for me it seems the best way to use native filters...it still brings interactivity and has a lot of advantagens in comparison to using variable input field.

But if you really want it than I recomend to use this one https://github.com/erikwett/qsVariable

Do the following:

  1. Create variable vEmpLoc in variable section
  2. Add this extension to the sheet and select as type input (I guess you get to this point )
  3. Than you will have to create set analysis in each object where you want this varible to take effect
    1. e.g. in table you gave as example add following to your MEASURE: Count({$<"Employee Location"={'$(vEmpLoc'}>}ID)

If any question, ask