Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

drop down list inside table box

Hello,

I have sample data like this:

IDTicketNoCurrencyPaidRcvdBalance
1US320USD200
2US324USD-110
3TXN40190
4UK119EUR176
5UK121EUR-76
6UK128EUR-100
7TXN4310

Balance=Paid+Rcvd. and that is represented by "TicketNo" starts with TXN. I need another column that will contain "ID" of the Transaction (see ID col)  relevant to each row. Like:

IDTicketNoCurrencyPaidRcvdBalanceRelevant_TXN_ID
1US320USD2003
2US324USD-1103
3TXN401903
4UK119EUR1767
5UK121EUR-767
6UK128EUR-1007
7TXN43107

This last column - "Relevant_TXN_ID"- is what the end user will put values into. I know a way through: INPUTFIELD.

But is it possible to have a drop-down list created for the last column( Relevant_TXN_ID )?? That will only require the user to choose the value (hence typo error can be avoided).

7 Replies
Gysbert_Wassenaar

No, there's no possibility to limit the values users can enter in an Input Field.


talk is cheap, supply exceeds demand
SunilChauhan
Champion II
Champion II

select field from general tab and go to presentation-select dropdown

see the screen shot

Sunil Chauhan
Not applicable
Author

Hi Sunil,

Please explain with below one example..

YearMonth
2013Jan
2013Feb
2013Mar
2013Apr
2014May
2014Jun
2014Jul
2014Aug
2014Oct

Thanks in advance...

Sub2u    

Not applicable
Author

Thanks Sunil. But that will not represent a drop-down-with-values for input. It will simply act as a filter. I need a drop-down to insert values in that column (and not to filter).

alkesh_sharma
Creator III
Creator III

Hello,

Inserting a value is only possible through an input box

Anonymous
Not applicable
Author

how to do the same in qliksense?

Gysbert_Wassenaar

Qlik Sense does not support input fields (yet). If your users should be able to enter data in a table then you need an qliksense extension (and other software) from for example jedox or K4 Analytics


talk is cheap, supply exceeds demand