drop down list inside table box

[#1]

Hello,

I have sample data like this:

ID	TicketNo	Currency	Paid	Rcvd	Balance
1	US320	USD	200
2	US324	USD		-110
3	TXN401				90
4	UK119	EUR	176
5	UK121	EUR		-76
6	UK128	EUR		-100
7	TXN431				0

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:

ID	TicketNo	Currency	Paid	Rcvd	Balance	Relevant_TXN_ID
1	US320	USD	200			3
2	US324	USD		-110		3
3	TXN401				90	3
4	UK119	EUR	176			7
5	UK121	EUR		-76		7
6	UK128	EUR		-100		7
7	TXN431				0	7

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).

[Gysbert_Wassenaar]

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

[SunilChauhan]

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

see the screen shot

[#4]

Hi Sunil,

Please explain with below one example..

Year	Month
2013	Jan
2013	Feb
2013	Mar
2013	Apr
2014	May
2014	Jun
2014	Jul
2014	Aug
2014	Oct

Thanks in advance...

Sub2u    

[#5]

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]

Hello,

Inserting a value is only possible through an input box

[Anonymous]

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