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: 
Not applicable

Column no/row no as dimension in pivot table

Hi all

I have the following pivot table. I want to add the red values as calculated dimension (these values are the number of the columns), but I'm not able to do that. Is there any function which I can use? Loading the rowno in the script is not a possibility.

Country

012014

1

022014

2

032014

3

country1200300400
country2300400500

Thank you in advance!

13 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Here it is an example

Not applicable
Author

Thank you, but that is not what I'm looking for.

It could also be like this, so April could also be '1' and one or more months may be missing..

Country

042014

1

052014

2

072014

3

country1200300400
country2300400500
Anonymous
Not applicable
Author

can try use ColumnNo(total) as expression.

sivarajs
Specialist II
Specialist II

Use RowNo(Total)

Not applicable
Author

Thank you both, but that doesn't give me the desired result either.

I really need to add it as calculated dimension, but I don't think this is possible

Anonymous
Not applicable
Author

I think you can drag the expression like the 'fake' dimension in pivot table.

CELAMBARASAN
Partner - Champion
Partner - Champion

Try

Aggr(FieldName & Chr(13) & Chr(10) & RowNo(), FieldName)

Make the Wrap header text-->Header height to 2 lines in Presentation tab

Not applicable
Author

Yes, that's possible, but then I get the following result:

Result.JPG.jpg

arjunkrishnan
Partner - Creator II
Partner - Creator II

Hai Britt...

I just try This One Expression Dimension Field I hope U I'll Help it to u

Aggr(CODE& Chr(10) & RowNo(), CODE)

OR

CODE &''&Left(CODE,1)

My Output Like That

By

ArjunKrish