topic Multiple text Color for expressions in Single Cell. in QlikView

Multiple text Color for expressions in Single Cell.

rahulsud007 — Wed, 03 Feb 2016 06:46:25 GMT

Dear All,

We have a requirement in which we need to show multiple text colors as shown in the pic.

From Image,

For 2015 Budget the 287.1 is the the value sum(Budget For that month).

chr(10) to bring next expression to next line.

ie -3.6%(in Red Color).

The next expression (sum(Actual for that month)/sum(Budget For that month))-1 if the value is <0, red, else green.

Also attaching a sample QVW.

Is there any way how we can achieve this?

Please help.

Thanks in advance..

Re: Multiple text Color for expressions in Single Cell.

marcus_sommer — Wed, 03 Feb 2016 06:50:43 GMT

It's not possible to have more then one color, font and so on in one single cell - you will need to split into two rows per each dimension-value.

- Marcus

Re: Multiple text Color for expressions in Single Cell.

jagan — Wed, 03 Feb 2016 06:54:32 GMT

HI,

it is not possible to display multi colors with in a single cell, instead you can display them in different cells/rows and format it accordingly.

Regards,

jagan.

Re: Multiple text Color for expressions in Single Cell.

rahulsud007 — Wed, 03 Feb 2016 06:54:47 GMT

Hi Marcus,

Thanks for your advice. Can you please let me know how we can split a single expression in to multiple rows?

Re: Multiple text Color for expressions in Single Cell.

jyothish8807 — Wed, 03 Feb 2016 06:57:23 GMT

Hi Rahul,

This not possible in your case, try using a pivot table then it can be easily achieved.

Regards

Re: Multiple text Color for expressions in Single Cell.

rahulsud007 — Wed, 03 Feb 2016 06:57:53 GMT

Hi Jagan,

Can you help us with an sample of what u r saying (ie formatting row wise/ cell wise)?

Thanks..

Re: Multiple text Color for expressions in Single Cell.

rahulsud007 — Wed, 03 Feb 2016 06:58:32 GMT

HI KC,

It is in Pivot table.

But I am not getting it.

Re: Multiple text Color for expressions in Single Cell.

marcus_sommer — Wed, 03 Feb 2016 06:58:50 GMT

You could add a second calculated dimension maybe with a valuelist like:

valuelist('values', '% from x')

and in your expressions something like:

if(valuelist('values', '% from x') = 'values', sum(YourValuesExp), sum(YourPercentExp))

- Marcus

Re: Multiple text Color for expressions in Single Cell.

jyothish8807 — Wed, 03 Feb 2016 07:03:25 GMT

Right now you have created all the calculation in one expression. Try to break them into multiple expressions. Then you will have different entries for Actual, budget and others. Then you can do color formation on expression level.

Regards