Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

how to give heading for expressions

Hi,

i am having 3 dimensions and 8 expressions in pivot table,i want to give the some text information in expression heading.4 expression in 1 text information

and 4 expressions in 1 text information.for ex..

Closing Stock ShareTertiary Sales Share
Jan-12Dec-11Nov-11Oct-11Jan-12Dec-11Nov-11Oct-11
0.53%0.31%0.49%0.97%0.36%0.50%0.66%0.87%
0.03%0.07%0.01%0.16%0.09%0.03%0.09%0.31%
3.06%1.97%0.34%0.05%2.49%0.66%0.32%0.03%
0.40%0.34%0.27%0.30%0.99%0.95%0.40%1.23%
12.30%12.00%10.88%10.70%14.24%17.26%12.76%13.66%

  here closing stock share and tertiary sales share i want to display as a expresions heading.

here jan-12,dec-11,nov-11,etc...is the calculated expresion name i taken in heading

regards,

ba

4 Replies
v_iyyappan
Valued Contributor

how to give heading for expressions

Hi,

     Cau u attach a sample QV file?

Iyyappan

jason_michaelid
Honored Contributor II

how to give heading for expressions

What exactly do you want the expression headings to say?

Not applicable

how to give heading for expressions

Hi

I want to display Closing Stock Share and Tertiary Sales Share as a expressions column names,under these i want to show 4 expressions for each heading like Jan12,Dec11,Nov11,etc..but it is calculated expression names.

pls find the above table,

reg,

ba

MVP
MVP

how to give heading for expressions

Hi ba

You can get the look you want using a pivot table. Set up the two heading rows in your examples as dimensions, and drag to the top of the table.

Its best if the dimensions are field names but if you cant load them in script, you can use calculated dimensions. If you need help with the calc dimensions, then you will need to be more specific about your requirements.

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Community Browser