topic Re: Inputbox with predifined Values using RGB, comma problem in QlikView

Inputbox with predifined Values using RGB, comma problem

chrweber — Thu, 12 Apr 2018 12:11:29 GMT

Hi,

I wish to provide an inputbox with predefined Colors that I load in script

LOAD *

Inline [

CustomColor

=Red()

=Blue()

=Yellow()

'=RGB(96,112,169)'

](delimiter is ';');

Those Colors are to be used as predefined Values which fails, as the predefined values are supposed to be comma separated:

=concat(CustomColor, ',')

Can I change the delimiter for the predefined values?

Or how else can I define a color without comma

Re: Inputbox with predifined Values using RGB, comma problem

Anonymous — Thu, 12 Apr 2018 12:40:22 GMT

The inline table doesn't recognize functions. Every piece of data is considered a textstring.

If this is the expected output, you can define a variable with the value vColor = RGB(96,112,169)

then use the variable in your inline load.

Re: Inputbox with predifined Values using RGB, comma problem

marcus_sommer — Thu, 12 Apr 2018 13:17:20 GMT

Instead of the rgb() function you could use the color-index behind the rgb. How it worked see here: Colors in Qlik.

- Marcus

Re: Inputbox with predifined Values using RGB, comma problem

Anil_Babu_Samineni — Thu, 12 Apr 2018 13:23:44 GMT

Are you asking Inputbox? But we don't have RGB for IB. So, I would ask you to share expected result

Re: Inputbox with predifined Values using RGB, comma problem

jonathandienst — Thu, 12 Apr 2018 13:33:32 GMT

This should work:

LOAD Evaluate(CustomColor) as CustomColor

Inline [

CustomColor

Red()

Blue()

Yellow()

RGB(96,112,169)

](delimiter is ';');

They will be converted to RGB values but the colours will be correct.

Re: Inputbox with predifined Values using RGB, comma problem

chrweber — Thu, 12 Apr 2018 14:28:22 GMT

Any function is just text until it is evaluated.

Your answer does not help, unfortunalely.

Re: Inputbox with predifined Values using RGB, comma problem

chrweber — Thu, 12 Apr 2018 14:30:57 GMT

That appears to be an adequate solution however it means that I am stuck with the qlik color pallete, which I am trying to circumvent.

However, concluding from your evasion, I assume that I cannot change the parsing of the inputbox.

Re: Inputbox with predifined Values using RGB, comma problem

chrweber — Thu, 12 Apr 2018 14:32:45 GMT

I would like the input box to contain the color strings and for the inputbox to accept those color strings

Re: Inputbox with predifined Values using RGB, comma problem

chrweber — Thu, 12 Apr 2018 14:35:55 GMT

That is interesting, and might be helpful for another task.

Unfortunately your suggestion makes it even worse, as now every string contains commas, that lead to parsing problems in the inputbox.

Unless there is a representation of colors that does not contain color ?

Re: Inputbox with predifined Values using RGB, comma problem

marcus_sommer — Thu, 12 Apr 2018 14:46:36 GMT

I wouldn't say that there is no way to bypass it within an inputbox but I think it won't be sensible because it would need some efforts and probably also have some further disadvantages. Especially if there much easier solutions possible.

At first I suggest using a listbox and not an inputbox and then extending the suggestion from Jonathan you could use:

LOAD dual(CustomColor, num(Evaluate(ColorIndex))) as CustomColor

Inline [

CustomColor, ColorIndex

Red; Red()

Blue; Blue()

Yellow; Yellow()

OtherColor; RGB(96,112,169)

](delimiter is ';');

and then the users could just select within the listbox.

- Marcus

Re: Inputbox with predifined Values using RGB, comma problem

chrweber — Thu, 12 Apr 2018 16:44:33 GMT

Thank you for that educational piece of script.

I have played a little but am not fully satisfied, yet.

I have two open questions

First, why not use an inputbox, when I want do define variables using predefined values?

Second, how can I evaluate the associated values? When I want do define the color of a textbox I can use the ColorIndex, but not the ColorName.

Best Regards

Re: Inputbox with predifined Values using RGB, comma problem

chrweber — Thu, 12 Apr 2018 17:03:58 GMT

I have played a little more and it appears that I want to "dereference" the 'dualed' field.

When putting the number of the color into the color fields, they change color as expected.

Using their names, does not work

Re: Inputbox with predifined Values using RGB, comma problem

MarcoWedel — Thu, 12 Apr 2018 22:54:06 GMT

Hello Jonathan,

I was about to post the same solution until realizing you already had the idea, so I just add a picture to your solution.

Marco

Re: Inputbox with predifined Values using RGB, comma problem

marcus_sommer — Fri, 13 Apr 2018 06:52:09 GMT

After all I'm not sure if I understand what do you want to do where and why but I think to assign a color worked both per fieldselection (also with dual-values) and per variable with a predefined valuelist created per expression. Personally I think I would prefer the selection approach.

- Marcus

Re: Inputbox with predifined Values using RGB, comma problem

chrweber — Fri, 13 Apr 2018 07:16:27 GMT

Thank you for that app.

I have arrived at that solution as well.

The problem with selection is that I have 6 color variables, each with its own selectable color.

Starting from the current solution I would like to display the color labels as predefined values and then use the colors for coloring like

=only({1<CustomColor = $(vColor)>} '='&ColorVariableConcat)

But this does not appear to work

Re: Inputbox with predifined Values using RGB, comma problem

marcus_sommer — Fri, 13 Apr 2018 07:26:24 GMT

Re: Color Formulas wont evaluate Color String