Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tracycrown
Creator III
Creator III

Cannot display text in expression

Dear all

Kindly advise how to display Student Name (text) in expression ?.

I am expecting the answer in following format but cannot get it right :

Class        Japan          China           .. ... Country

1st            Name 1        Name 7       ......

1st            Name 2        Name 8

2nd           Name 3        Name 9

2nd           Name 4        Name 10

Thank you, Tracy

6 Replies
gautik92
Specialist III
Specialist III

Hope it helps you

qlikviewwizard
Master II
Master II

Hi Tracy,

Please check the attached file.

Capture.PNG

Capture1.PNG

pokassov
Specialist
Specialist

Hi!

Add Students as dimension, remove your expression and add expression 1.

Then hide this expression on the Presentation tab

tracycrown
Creator III
Creator III
Author

Dear all

Many thanks for your quick suggestions.

Can someone help to illustrate how to use cross table in script and show report in pivot rather than straight table ?.

Thank you, Tracy

qlikviewwizard
Master II
Master II

Hi Tracy,

Check these links. Hope this will help you.

Loading Cross Tables

USDOTCrossTable.qvw

tracycrown
Creator III
Creator III
Author

Dear Sir

Please send me an example of your data in sheet2 using pivot table rather than text box or straight table.

I have no problem if the data is numeric (eg Sales), my current problem is how to present the text (eg Product Name) ?.

Thank you, Tracy