topic Re: drop down list inside table box in QlikView

drop down list inside table box

Wed, 24 Dec 2014 09:51:22 GMT

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

Re: drop down list inside table box

Gysbert_Wassenaar — Wed, 24 Dec 2014 09:58:32 GMT

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

Re: drop down list inside table box

SunilChauhan — Wed, 24 Dec 2014 09:59:16 GMT

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

see the screen shot

Re: drop down list inside table box

Thu, 25 Dec 2014 05:08:21 GMT

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

Re: drop down list inside table box

Fri, 26 Dec 2014 07:33:32 GMT

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

Re: drop down list inside table box

alkesh_sharma — Fri, 26 Dec 2014 07:46:24 GMT

Hello,

Inserting a value is only possible through an input box

Re: drop down list inside table box

Anonymous — Mon, 18 Jun 2018 12:15:33 GMT

how to do the same in qliksense?

Re: drop down list inside table box

Gysbert_Wassenaar — Tue, 19 Jun 2018 06:14:51 GMT

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