Re: Cannot display text in expression - Qlik Community

tracycrown · ‎2015-09-10

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 · ‎2015-09-10

Hope it helps you

qlikviewwizard · ‎2015-09-10

Hi Tracy,

Please check the attached file.

pokassov · ‎2015-09-10

Hi!

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

Then hide this expression on the Presentation tab

tracycrown · ‎2015-09-10

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 · ‎2015-09-11

Hi Tracy,

Check these links. Hope this will help you.

tracycrown · ‎2015-09-11

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