topic Cannot display text in expression in QlikView

Cannot display text in expression

tracycrown — Thu, 10 Sep 2015 08:55:10 GMT

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 — Thu, 10 Sep 2015 09:05:18 GMT

Hope it helps you

qlikviewwizard — Thu, 10 Sep 2015 09:05:55 GMT

Hi Tracy,

Please check the attached file.

pokassov — Thu, 10 Sep 2015 09:12:05 GMT

Hi!

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

Then hide this expression on the Presentation tab

tracycrown — Thu, 10 Sep 2015 10:03:44 GMT

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 — Fri, 11 Sep 2015 04:20:44 GMT

Hi Tracy,

Check these links. Hope this will help you.

tracycrown — Fri, 11 Sep 2015 06:11:38 GMT

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