Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

varmekontrol
New Contributor II

Change color for stacked barchart, using Wildmatch

HI

I have this stacked bar chart.

Udklip.JPG

Measure 1:

count(distinct if(WildMatch(sgw_operation_state_art, '*Exchange*') and sgw_deactivation_date<=0, gateway_id))

Measure 2:

count(distinct if(WildMatch(sgw_operation_state_art, '*Check*') and sgw_deactivation_date<=0, gateway_id))

I would like to color these two bars.

Attempt 1: (Does not work)

if(wildmatch(sgw_operation_state_art, '*Exchange*'), RGB(230,63,12),if(wildmatch(sgw_operation_state_art, '*Check*'), RGB(230,63,12)))

Attempt 2: (does not work)

pick(WildMatch(sgw_operation_state_art, '*Exchange*', '*Check*'), RGB(230,63,12), RGB(230,63,12))

5 Replies
YoussefBelloum
Esteemed Contributor

Re: Change color for stacked barchart, using Wildmatch

Hi,

I don't see a problem with your coloring expressions, both should work fine.. did you try to check and uncheck the checkbox under the coloring expression box ?

agigliotti
Honored Contributor II

Re: Change color for stacked barchart, using Wildmatch

what are the chart dimensions and measures ?

varmekontrol
New Contributor II

Re: Change color for stacked barchart, using Wildmatch

Measure 1:

count(distinct if(WildMatch(sgw_operation_state_art, '*Exchange*') and sgw_deactivation_date<=0, gateway_id)) 

  1. count(distinct if(WildMatch(sgw_operation_state_art, '*Check*') and sgw_deactivation_date<=0, gateway_id)) 
varmekontrol
New Contributor II

Re: Change color for stacked barchart, using Wildmatch

The box has been checked and unchecked with no result.

imhappiee
New Contributor III

Re: Change color for stacked barchart, using Wildmatch


Hi

try this two and see if these are working


pick(WildMatch(sgw_operation_state_art, '*Exchange*', '*Check*'), RGB(230,63,12))


else

if(wildmatch(sgw_operation_state_art, '*Exchange*', '*Check*'), RGB(230,63,12)) 


Anand

Community Browser