Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
adamgaox
Creator
Creator

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
stigchel
Partner - Master
Partner - Master

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

PivotColors2.png

View solution in original post

14 Replies
stigchel
Partner - Master
Partner - Master

Yes you can see attached

stigchel
Partner - Master
Partner - Master

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

PivotColors.png

adamgaox
Creator
Creator
Author

Hi Piet,

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

Thanks for your reply.

stigchel
Partner - Master
Partner - Master

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

stigchel
Partner - Master
Partner - Master

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

PivotColors2.png

adamgaox
Creator
Creator
Author

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
Creator
Creator
Author

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

stigchel
Partner - Master
Partner - Master

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

stigchel
Partner - Master
Partner - Master

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.