Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
adamgaox
Contributor

Conditional Text Color expression values

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.

PERSONYMPRODUCTFLAG
ADAM201401A1
ADAM201401B2
ADAM201401C3
ADAM201401D1


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

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


1 Solution

Accepted Solutions
Partner
Partner

Re: Conditional Text Color expression values

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

PivotColors2.png

View solution in original post

14 Replies
Partner
Partner

Re: Conditional Text Color expression values

Yes you can see attached

Partner
Partner

Re: Conditional Text Color expression values

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

PivotColors.png

adamgaox
Contributor

Re: Conditional Text Color expression values

Hi Piet,

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

Thanks for your reply.

Partner
Partner

Re: Conditional Text Color expression values

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

Partner
Partner

Re: Conditional Text Color expression values

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

PivotColors2.png

View solution in original post

adamgaox
Contributor

Re: Conditional Text Color expression values

I know what you mean.

Actually I'll cross the pivot not like the straight table:屏幕快照 2015-06-03 下午9.44.06.png

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

This is what troubles me.

adamgaox
Contributor

Re: Conditional Text Color expression values

Hi Piet,

Thanks.I think this is an acceptable effect.

This is what I do after adding YM dimension.

Thank you very much.

屏幕快照 2015-06-03 下午9.51.40.png

Partner
Partner

Re: Conditional Text Color expression values

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.

PivotColors3.png

Partner
Partner

Re: Conditional Text Color expression values

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.