topic Re: Conditional Text Color expression values in QlikView

Conditional Text Color expression values

adamgaox — Wed, 03 Jun 2015 13:11:35 GMT

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

PERSON

201401

ADAM

A,D

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).

Re: Conditional Text Color expression values

stigchel — Wed, 03 Jun 2015 13:24:14 GMT

Yes you can see attached

Re: Conditional Text Color expression values

stigchel — Wed, 03 Jun 2015 13:26:52 GMT

You can use the text color option of the expression (cclick on the plus sign in front)

Re: Conditional Text Color expression values

adamgaox — Wed, 03 Jun 2015 13:29:38 GMT

Hi Piet,

I've tried this way.Can it be achieved without setting Flag as the dimension?

Thanks for your reply.

Re: Conditional Text Color expression values

stigchel — Wed, 03 Jun 2015 13:36:04 GMT

No, not really.

You can sort of hide the flag dimension, by removing the label, setting the font to transparent color, making the column smaller

Re: Conditional Text Color expression values

stigchel — Wed, 03 Jun 2015 13:40:11 GMT

When you do, it looks like this. Can you see there is a second dimension?

Re: Conditional Text Color expression values

adamgaox — Wed, 03 Jun 2015 13:45:58 GMT

I know what you mean.

Actually I'll cross the pivot not like the straight table:

My client prefer the table right side with colors rather than the left side.

This is what troubles me.

Re: Conditional Text Color expression values

adamgaox — Wed, 03 Jun 2015 13:53:57 GMT

Hi Piet,

Thanks.I think this is an acceptable effect.

This is what I do after adding YM dimension.

Thank you very much.

Re: Conditional Text Color expression values

stigchel — Wed, 03 Jun 2015 13:54:21 GMT

Other work around, maybe you can combine the person and Flag dimension:

=Person&' '&Flag

The spaces are to hide the flag text on the right.

Re: Conditional Text Color expression values

stigchel — Wed, 03 Jun 2015 14:00:02 GMT

You're welcome. If this has answered your question, could you please mark the relevant answers correct\helpfull? It will help others find correct answers to similar issues and let other contributing members know this requires no more attention.

Re: Conditional Text Color expression values

adamgaox — Wed, 03 Jun 2015 14:00:17 GMT

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.

Re: Conditional Text Color expression values

stigchel — Wed, 03 Jun 2015 14:11:41 GMT

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).

Re: Conditional Text Color expression values

adamgaox — Wed, 03 Jun 2015 14:22:55 GMT

Umm,yeah.

Hoping for next discussion.

Re: Conditional Text Color expression values

stigchel — Wed, 03 Jun 2015 14:28:16 GMT

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)

Re: Conditional Text Color expression values

adamgaox — Wed, 03 Jun 2015 14:40:12 GMT

Yes,dual() is powerful function.