Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need to solve this:
my pivot table is currently showing 3 columns; Teaching Detail, Status, Remarks.
For Status, it is displaying in 1,2 or 3.
I need to replace this Status column with my [Rating Label] which are in text.
Can some one guide me on how to go about this?
I have attached the qvw for your convenience. Please refer to CME tab for easy reference.
Thanks!
Chun Wey
Try expression:
=If([Question Labels]='Status',
Only({<QuestionType={'CME'}>}RatingLabel) ,Only({<QuestionType={'CME'}>}QuestionData )
)
Chunwey,
Inline will work here:
Load * Inline[
Status, Rating_Label
1, Rating1
2,Rating2
3,Rating3
]
Resident Your_table;
Hi Amit,
thanks for your response.
I already had this table in my table structure. It is linked by RatingID as the key.
Try expression:
=If([Question Labels]='Status',
Only({<QuestionType={'CME'}>}RatingLabel) ,Only({<QuestionType={'CME'}>}QuestionData )
)
Oh Sorry,
If this is the case , it can be possible with Applymap function.
See this attachment.
Thanks,
AS
Thanks Tresesco for the Only expression. I will rmb to use this more often.
Thank for your attached QVW. It is more helpful..