Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
So, instead of showing table A below, I want to format it like table B.
Thanks
Table A:
Project ID | Submitted Item ID |
123 | Apple |
123 | Banana |
123 | Orange |
123 | Pear |
456 | Banana |
456 | Orange |
456 | Pear |
456 | Watermelon |
Table B:
Project ID | Submitted Item ID |
123 | Apple |
Banana | |
Orange | |
Pear | |
456 | Banana |
Orange | |
Pear | |
Watermelon |
Create extra expression
Enter 1
Hide the Expression in presentation tab
In Dimensions under Text use
=if(RowNo()=1,Black(),White())
Feeling Qlikngry?
Create extra expression
Enter 1
Hide the Expression in presentation tab
In Dimensions under Text use
=if(RowNo()=1,Black(),White())
Feeling Qlikngry?
Awesome Robert
Smart Solution:)