List Index No in Listbox - Page 2 - Qlik Community

Anonymous · ‎2011-09-07

Hi,

Is there any way to get the position no (list nidex no) of an item in a list box. I tried using Match function but its not working as there are repeat entries. The field on which the list box is generated its primary key for 2 tables also, which restricts using match and index functions. Is there any other way for this. Kindly help.

kaushiknsolanki · ‎2011-09-07

Hi,

Then you can try like this.

Type below expression in your textbox.

='Serial No. = ' & FieldValue('KeyID',num(month))

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Anonymous · ‎2011-09-07

Thank you Kaushik, I tried the same, but Its not working.

kaushiknsolanki · ‎2011-09-07

Hi,

Ok can you tell me in what format your month field look like.

Is it coming as a field from your database..?

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Anonymous · ‎2011-09-07

Yes, but its in text format like January and Feb. But I have nothing to do with Month field in the report. I cant consider because in the report section I wont be using the month as the loop, it should be KEYID

kaushiknsolanki · ‎2011-09-07

Hi,

OK try this then

='Serial No =' & Concat(KeyID,',')

Also have a look at the attached file.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Anonymous · ‎2011-09-07

Kaushik,

Thank you for your assistance. But Along with the KeyID, Iw ill be needing the serial no of the KeyID in the list also. Attached is a word document, which says how it should look like.