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: 
fj11
Contributor
Contributor

Column Label

Hi ,

I have a requirement as below:

targettarget ratetargettargettarget rate

i.e i need different headers for column 1,3,4 i need header as target whereas for 2,5 i need header as 'target rate'.

I have tried ColumnNo(TOTAL) in order o recognize the column no but it doesn't work?

Is there any workaround that i can get column number for column labels??

NOTE: I AM USING PIVOT TABLE.

Thnaks,

Falguni

8 Replies
binujose1982
Contributor III
Contributor III

Hi Falguni,

Could you please share you sample source data?

Regrsds,

Binu

yujiyamane
Creator II
Creator II

Hi Falguni,

You just need to manually add the text and number in the label of dimension.

Go to Dimensions > Select a field > Label > Add text like 'target 1'

Hopefully this helps you.

Let me know if i can be of any more help.

Yuji

fj11
Contributor
Contributor
Author

Hi Binu,

Capture.PNG

As you can see i need different labels. example 'Target pro rata' and 'Target'.

In order to acheive this i need to know the Column No.

Hope you get my issue now

Thanks,

falguni

fj11
Contributor
Contributor
Author

Hi Yuji,

My 'Target Pro data' or 'Target' is an expression and not a dimension

Capture.PNG

As you can see i need different labels. example 'Target pro rata' and 'Target'.

In order to acheive this i need to know the Column No.

Hope you get my issue now

Thans,

falguni

Anonymous
Not applicable

Hi,

Even the expression has a label field. This should be above the expression definition field. Go to expressions, enter the expression definition and above that, Enter any label you desire

fj11
Contributor
Contributor
Author

I am trying to make changes in the label itself. But this thing is I cant use ColumnNo(TOTAL) in the column labels

Anonymous
Not applicable

What do you need the column to show

fj11
Contributor
Contributor
Author

Hi Thabang,

I need table labels as below:

Capture.PNG

You can see 'Target pro rata' and 'Target' labels here ...so for Column 1,3,4 i need label as 'Target pro rata' and for column 2,5 i need label as 'Target'

In order to identify which Column i need the labels i need column no .

I hope it is clear to you

Note that the formula for target pro rata and target is the same... its just that i need different labels

Thanks,

falguni