Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

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

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

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

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

Try expression:

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

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

)

View solution in original post

6 Replies
Highlighted
Master III
Master III

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

Chunwey,

Inline will work here:

Load * Inline[

Status, Rating_Label

1, Rating1

2,Rating2

3,Rating3

]

Resident Your_table;

Highlighted
Not applicable

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

Hi Amit,

thanks for your response.

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

Highlighted
MVP
MVP

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

Try expression:

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

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

)

View solution in original post

Highlighted
Master III
Master III

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

Oh Sorry,

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

See this attachment.

Thanks,

AS

Highlighted
Not applicable

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

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

Highlighted
Not applicable

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

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