Cannot display text in expression

[tracycrown]

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

[gautik92]

Hope it helps you

[qlikviewwizard]

Hi Tracy,

Please check the attached file.

[pokassov]

Hi!

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

Then hide this expression on the Presentation tab

[tracycrown]

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]

Hi Tracy,

Check these links. Hope this will help you.

Loading Cross Tables

USDOTCrossTable.qvw

[tracycrown]

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