Qlik sense User input interface

[Anonymous]

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!

[DavidŠtorek]

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]

Do created reference of input variable and employee table?

[kkkumar82]

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

[kkkumar82]

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

[DavidŠtorek]

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

[Anonymous]

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]

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

[Anonymous]

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

[DavidŠtorek]

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