topic Re: Column Label in QlikView

Column Label

fj11 — Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

I have a requirement as below:

target	target rate	target	target	target 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

Re: Column Label

binujose1982 — Wed, 14 Mar 2018 00:25:57 GMT

Hi Falguni,

Could you please share you sample source data?

Regrsds,

Binu

Re: Column Label

yujiyamane — Wed, 14 Mar 2018 00:46:41 GMT

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

Re: Column Label

fj11 — Wed, 14 Mar 2018 05:33:14 GMT

Hi Binu,

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

Re: Column Label

fj11 — Wed, 14 Mar 2018 05:35:00 GMT

Hi Yuji,

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

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

Re: Column Label

Anonymous — Wed, 14 Mar 2018 08:13:36 GMT

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

Re: Column Label

fj11 — Wed, 14 Mar 2018 08:20:23 GMT

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

Re: Column Label

Anonymous — Wed, 14 Mar 2018 08:22:30 GMT

What do you need the column to show

Re: Column Label

fj11 — Wed, 14 Mar 2018 08:29:13 GMT

Hi Thabang,

I need table labels as below:

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