Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

falgunijadhav
New 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

Tags (2)
8 Replies
binujose1982
New Contributor III

Re: Column Label

Hi Falguni,

Could you please share you sample source data?

Regrsds,

Binu

yujiyamane
Contributor II

Re: Column Label

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

falgunijadhav
New Contributor

Re: Column Label

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

falgunijadhav
New Contributor

Re: Column Label

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

thabang_petje
Contributor III

Re: Column Label

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

falgunijadhav
New Contributor

Re: Column Label

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

thabang_petje
Contributor III

Re: Column Label

What do you need the column to show

falgunijadhav
New Contributor

Re: Column Label

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

Community Browser