topic Re: Display values from list box to text Object in QlikView

Display values from list box to text Object

noman212 — Sat, 04 Jul 2015 04:41:09 GMT

Hi Community,

I have a List Box which display values from table i want to display top 5 values separately in 5 text Objects..

Text Object 1 Contains first value from the list Box

Text Object 2 Contains Second value from the list Box

Text Object 3 Contains third value from the list Box

Text Object 4 Contains fourth value from the list Box

Text Object 5 Contains fifth value from the list Box

Need your help..

Regards

Noman khan

Re: Display values from list box to text Object

PrashantSangle — Sat, 04 Jul 2015 04:54:28 GMT

If list box contain numerical value.

Then try

max(filedname,1)

max(filedname,2)

max(filedname,3)

max(filedname,4)

max(filedname,5)

Regards

Re: Display values from list box to text Object

noman212 — Sat, 04 Jul 2015 05:10:22 GMT

This is Ok but i want to display related data for top 5 clients

Like client 1 have to pay premium 500K and his sum assured is 123K and his Consultant name is XYZ i want to Show these informations in a separate textbox like

Client = John

Premium = 5000

Sum Assured = 250

Consultant name = XYZ Bank.

Re: Display values from list box to text Object

sunny_talwar — Sat, 04 Jul 2015 12:58:00 GMT

Try this may be in a list box:

For Max fieldname

='Client = ' & Only({<fieldname = {"$(=Max(filedname,1))"}>} ClientName) & Chr(13) &

'Premium = ' & Sum({<fieldname = {"$(=Max(filedname,1))"}>} Premium) & Chr(13) &

'Sum Assured = ' & Sum({<fieldname = {"$(=Max(filedname,1))"}>} [Sum Assured]) & Chr(13) &

'Consultant Name= ' & Only({<fieldname = {"$(=Max(filedname,1))"}>} [Consultant Name])

For 2nd Max fieldname

='Client = ' & Only({<fieldname = {"$(=Max(filedname,2))"}>} ClientName) & Chr(13) &

'Premium = ' & Sum({<fieldname = {"$(=Max(filedname,2))"}>} Premium) & Chr(13) &

'Sum Assured = ' & Sum({<fieldname = {"$(=Max(filedname,2))"}>} [Sum Assured]) & Chr(13) &

'Consultant Name= ' & Only({<fieldname = {"$(=Max(filedname,2))"}>} [Consultant Name])

and so on...

HTH

Best,

Sunny