Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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).
When you do, it looks like this. Can you see there is a second dimension?
Yes you can see attached
You can use the text color option of the expression (cclick on the plus sign in front)
Hi Piet,
I've tried this way.Can it be achieved without setting Flag as the dimension?
Thanks for your reply.
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
When you do, it looks like this. Can you see there is a second dimension?
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.
Hi Piet,
Thanks.I think this is an acceptable effect.
This is what I do after adding YM dimension.
Thank you very much.
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.
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.