Is there an easy way to recreate this look in Qlik?

[fcecconi]

Hello

I have a requirement to have a table looking like this.  I am can come close, but I dont see a cell merge option in any object.

Widget 1			Process
Field 1		Field 2	Measure
KPI 1		95.0 – 105.0%
KPI 2	Option 1	NMT 0.10%
	Option 2	NMT 1.0%
KPI 3		20 – 33%
KPI 4		NLT 80%

Is there an easy way to create this in Qlik?

Thanks!

[jpenuliar]

It looks more like a pivot table

[alexandros17]

You can use a pivot table to come close but to have exactly what you need is hard work

[#4]

Hi,

It can be possible through Visual cues in presentation tab in straight table,

or else we need to write some if condition

if(measure<=10,'red',if(measure>10 and measure<=20,'blue','grean'))

[mdmukramali]

Dear ,

can you share source data structure ( sample Data).

Thanks,

[fcecconi]

Jonathan

that look is close.  Is there a way to have the table auto expand and also not show the + or -?

thanks

[jpenuliar · Accepted solution]

That will be Chart Properties> Presentation> Always Expanded

[fcecconi]

thanks.  I think this will work

[jpenuliar]

Cool, in terms of bg color of your measures, try a conditional RGB() in your expresion.