Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
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
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
amit_saini
Honored Contributor 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;

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.

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

amit_saini
Honored Contributor 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

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.

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..