Conditional Text Color expression values

[adamgaox]

Dear all,

I need to solve a problem.I’ve racked my brain to finish it.It seems difficult to me.

Thanks in advance.

I've a detail table like this.

PERSON	YM	PRODUCT	FLAG
ADAM	201401	A	1
ADAM	201401	B	2
ADAM	201401	C	3
ADAM	201401	D	1

I want to create a pivot table in qlikview like this (with conditional text color demands):

PERSON	201401
ADAM	A,D B C

As in this pivot table PRODUCT

     with Flag equals 1 font color is red

     with Flag equals 2 font color is blue

     with Flag equals 3 font color is green

If it's possible to achieve in qlikview ?(Thank you very much).

[adamgaox]

Thank you very much.It seems the discussion information is not dynamic updating.So I'm always late for getting your reply.This is really helpful.

Can we exchange mail address?It's really joyful to discuss about the techniques of qlikview.

[stigchel]

Hi Adam,

You're welcome, this is what the community is for, questions/discussing techniques. It's also the place where I want the discussion to be, so not via my email (sorry).

[adamgaox]

Umm,yeah.

Hoping for next discussion.

[stigchel]

Well, here's one

I just thought of a better way, that I did not think of that before...

Use this as your dimension, much better (Flag must be a number, which it is in the example)

=Dual(Person,Flag)

[adamgaox]

Yes,dual() is powerful function.