Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
abdulshaik2092
Contributor II
Contributor II

How to give user input for filtering purposes?

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

10 Replies
sunny_talwar

Can you elaborate on your requirement a little bit?

abdulshaik2092
Contributor II
Contributor II
Author

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.

abdulshaik2092
Contributor II
Contributor II
Author

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.X.JPG

el_aprendiz111
Specialist
Specialist

Hi look in Qv

Fil.gif

neelamsaroha157
Specialist II
Specialist II

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

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'

abdulshaik2092
Contributor II
Contributor II
Author

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

Could you check the sample file?

abdulshaik2092
Contributor II
Contributor II
Author

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?