topic How to show dimensions from different tables side by side in Pivot Table? in QlikView

How to show dimensions from different tables side by side in Pivot Table?

Thu, 04 Dec 2014 06:20:28 GMT

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

amit_saini — Thu, 04 Dec 2014 06:27:32 GMT

Chunwey,

Inline will work here:

Load * Inline[

Status, Rating_Label

1, Rating1

2,Rating2

3,Rating3

]

Resident Your_table;

Thu, 04 Dec 2014 06:32:55 GMT

Hi Amit,

thanks for your response.

I already had this table in my table structure. It is linked by RatingID as the key.

tresB — Thu, 04 Dec 2014 06:39:37 GMT

Try expression:

=If([Question Labels]='Status',

Only({<QuestionType={'CME'}>}RatingLabel) ,Only({<QuestionType={'CME'}>}QuestionData )

)

amit_saini — Thu, 04 Dec 2014 06:41:18 GMT

Oh Sorry,

If this is the case , it can be possible with Applymap function.

See this attachment.

Thanks,

Thu, 04 Dec 2014 06:50:24 GMT

Thanks Tresesco for the Only expression. I will rmb to use this more often.

Tue, 16 Dec 2014 06:43:01 GMT

Thank for your attached QVW. It is more helpful..