topic Re: Putting Together List Boxes? in QlikView

Putting Together List Boxes?

Fri, 11 Oct 2013 19:43:04 GMT

I don't know if someone else has asked this, but is there a way to join List Boxes into on List Box? More specifically I have for list boxes showing delinquency amounts, labeled "0-30 Days", "31-60 days", "61-90 days" and ">90 days". Is there a way to have a list box just titled "Delinquencies" that has these 4 categories as options that connects to the data from these 4 boxes?

Re: Putting Together List Boxes?

Clever_Anjos — Fri, 11 Oct 2013 19:49:21 GMT

You can prepare a table at script consolidating those fields

Re: Putting Together List Boxes?

Peter_Cammaert — Fri, 11 Oct 2013 19:54:01 GMT

How about turning your four list boxes into a single one, and prefixing each value with its category and a slash e.g. "0-30 Days" & "/" & "27", "0-30 Dats" & "/" & "28" etc.

Then enable the "Show as Tree View" option in ListBox->Properties->General.

Peter

Re: Putting Together List Boxes?

jagan — Sat, 12 Oct 2013 10:20:21 GMT

Hi,

If you have two date fields in your table, then the differences should between the two dates can be categorised like this

Load

FromDate,

ToDate,

If(Num(ToDate - FromDate) > 90, '>90 days',

If(Num(ToDate - FromDate) >60 and Num(ToDate - FromDate) <= 90, '61-90 days',

If(Num(ToDate - FromDate) >30 and Num(ToDate - FromDate) <= 60, '31-60 days',

If(Num(ToDate - FromDate) >0 and Num(ToDate - FromDate) <= 30, '0-30 days', 'N/A')))) AS Delinquencies

FROM Data;

Now use Delinquencies field as List/Filter box.

Hope this is what you are expecting.

Regards,

jagan.

Re: Putting Together List Boxes?

israrkhan — Sat, 12 Oct 2013 10:46:47 GMT

Hi John,

in above posts they have describe you script level solution.

but if you want design level, the try this one.

uncheck show caption for all list boxes on Caption tab. and show border as well.

then create a text object, give it color you want , and text "Delinquencies"

then arrange all list boxes like column, and put the txt box on top, it will look like list box header(caption)

see the attached example...