Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
shannoypaul
Contributor

Faking List boxes with Straight Table

Hi all,

I am trying to fake list boxes using a Straight table but my requirement is to have 2 columns in the list box, as shown below:

Capture.JPG

How can I achieve multiple columns using a straight table to fake list boxes.

TIA,

Shannoy

@johnwith

1 Solution

Accepted Solutions
el_aprendiz111
Valued Contributor

Re: Faking List boxes with Straight Table

Hi,

CHECK.gif

12 Replies
el_aprendiz111
Valued Contributor

Re: Faking List boxes with Straight Table

Hi,

libx.gif

adamdavi3s
Honored Contributor

Re: Faking List boxes with Straight Table

That is all well and good but that is multiple dimensions?

I believe Shannoy is looking for a way to wrap a single dimension into multiple columns which I don't think is possible

shannoypaul
Contributor

Re: Faking List boxes with Straight Table

Yes Adam, that is what I am looking for, I can do away with the checkboxes.

MVP & Luminary
MVP & Luminary

Re: Faking List boxes with Straight Table

Within the tab presentation are options to determine how many columns should be displayed:

- Marcus

adamdavi3s
Honored Contributor

Re: Faking List boxes with Straight Table

But you don't have that option on a chart.

He is trying to replicate that IN a chart as a pseudo listbox

MVP & Luminary
MVP & Luminary

Re: Faking List boxes with Straight Table

I don't think that it's possible to create a multi-column listbox view and behaviour within a table-chart - he will need to decide which death he want to die ... maybe a bit more informations what are the reasons behind them might help to find other/better solutions.

- Marcus

el_aprendiz111
Valued Contributor

Re: Faking List boxes with Straight Table

Hi,

CHECK.gif

shannoypaul
Contributor

Re: Faking List boxes with Straight Table

I need font color within the list box to be color coded

Green- Permanent

Orange- Temporary

Red- Intern

Source:

Capture3.JPG

List Box (O/P)

Capture1.JPG

MVP & Luminary
MVP & Luminary

Re: Faking List boxes with Straight Table

You couldn't have everything together. Within the tablechart you could color background and font like you want but you couldn't create a multi-column view/behaviour from a listbox.

Nevertheless I would use a listbox and add the color-code with an expression like in this example which used a gauge to display the color:

- Marcus