How to give user input for filtering purposes?

[Anonymous]

Hi,

So I have an Excel with Multiple tabs, One of the tab is "Features Filter" where in the last column user inputs "X" and clicks on SHOW DATA and this reflects the changes in another tab.

How can I get this functionality in QlikView??

TIA

[sunny_talwar]

Can you elaborate on your requirement a little bit?

[Anonymous]

In my Excel there is a tab named Feature Filters with 4 columns and around 950 rows and the user has to enter “X” in the last column in the particular row he decides to make a selection and then click on Show Data button which reflects changes in another tab (calculations happen in back-end). I am not worried about the calculations. I just want to know how to implement the User Inputting “X” functionality in QlikView.

I have created a Table Box to show all the Columns.

[Anonymous]

So, basically the user is selecting the first three rows by typing X in the 4th column. For better understanding I am adding a Screenshot.

[el_aprendiz111]

Hi look in Qv

[neelamsaroha157]

Create a variable 'X'.

Use this variable in the input box.

You can use Input box for user to input his value and that would be stored in the variable.

Use that variable in your calculation.

Hope this helps..

[Digvijay_Singh]

Check this out in the last sheet -

The variable value changes based on the row clicked in the last column, also clicked row display 'X'

[Anonymous]

Yes, the value X points to keeps changing based on where the user types X.

I am wondering if this functionality can be implemented in Qlikview or not.

Any thoughts or methods are appreciated.

[Digvijay_Singh]

Could you check the sample file?

[Anonymous]

Hello,

I checked the sample file. Similar to what I was looking for. One thing is for me the column is filled with X and for you the X is shown where you click.. how do you do that?