Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

abhaysingh
Contributor III

Logic Required

Hi Guys Below is the input data, in this on the basis of Test Measure output, there Color coding required. Please suggest

IDissRssTestOUTPUT Required
C1623832C/1M2C/1HC/H/M/LRED/RED/AMBER/GREEN
C1650071C/1H1HC/HRED/RED
C1659391M1MMAMBER
C1722911L1LLGREEN
C1746461H/1L1CH/LRED/GREEN
7 Replies
omarbensalem
Esteemed Contributor

Re: Logic Required

I think if conditions should work; sthing like:

if(Test='C',Red(),

if(Test='H',Red(),

if(Test='M',Amber(),

if(Test='L',Green()

))))

abhaysingh
Contributor III

Re: Logic Required

thanks , I tried but w.r.t single output it is working but if I have multiple string king output like C/H/M/L its not working

omarbensalem
Esteemed Contributor

Re: Logic Required

And u want to show this in a table object?

abhaysingh
Contributor III

Re: Logic Required

yes

omarbensalem
Esteemed Contributor

Re: Logic Required

You can't do that; you can't color a cell in a table with different colors..

abhaysingh
Contributor III

Re: Logic Required

ok , is it possible to color values from backend?

consultant_bi
Contributor

Re: Logic Required

except if he create 3 columns to display in each one the color he want , by the master dimensions of the same field Test

and in the content of the column just show nothing like :   if(len(test)<>0,' ') and also title if you want to change it,

and in expression of background color put for the first column you created this :

if(test='C',Red(),

if(test='C/H/L',blue(),

if(test='H/L',Red(),

)))

in the second one :

if(test='C/H/L',Green(),

if(test='H/L',green(),

))

and continue on the same logic

Sans titre.png