Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

satishgaba
New Contributor

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
Contributor III

Re: Qlik sense User input interface

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
Contributor II

Re: Qlik sense User input interface

Do created reference of input variable and employee table?

kkkumar82
Valued Contributor III

Re: Qlik sense User input interface

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

kkkumar82
Valued Contributor III

Re: Qlik sense User input interface

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

DavidŠtorek
Contributor III

Re: Qlik sense User input interface

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

satishgaba
New Contributor

Re: Qlik sense User input interface

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

satishgaba
New Contributor

Re: Qlik sense User input interface

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

satishgaba
New Contributor

Re: Qlik sense User input interface

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

DavidŠtorek
Contributor III

Re: Qlik sense User input interface

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

Community Browser