Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Showing a selection in a text box

Hey guys,

I'm having trouble showing a selection in a text box. The trouble is due to the selection comprising of multiple selections.

I'll use fake fields and rows for discussion purposes.

I have a field called 'Colours' with rows:

  • Red
  • Blue
  • Grey
  • Black

Now on a filter pane I've set it up so it shows

  • Red
  • Blue
  • Dark Colours

With the formula:

If(Colour = 'Red', 'Red',
If(Colour= 'Blue', 'Blue',

If(Match(Colour, 'Grey', 'Black'), 'Dark Colours')))

I also have a Text & Image visualisation set up with the same formula so when a colour is selected, it shows up there. However, when I select 'Dark Colours' it does not show up there, but Red and Blue do.

Does anyone know what I'm doing wrong for 'Dark Colours' to not appear in the text box? I'm guessing it's because more than one colour is selected (both Grey and Black). Does anyone know how to get around this?

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Re: Showing a selection in a text box

I just worked it out. In the Load statement I put in

If(Match(Colour, 'Grey', 'Black'), 'Dark Colours', 'Not Dark') As Test

and just referenced to that field in the Text visualisation.

1 Reply
Not applicable

Re: Showing a selection in a text box

I just worked it out. In the Load statement I put in

If(Match(Colour, 'Grey', 'Black'), 'Dark Colours', 'Not Dark') As Test

and just referenced to that field in the Text visualisation.

Community Browser