Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
vireshkolagimat
Contributor II

how to display changing column headers in labels in straight table

Hi Guys,

I have sample data in the below format.

Prod   27-May   3-Jun

A        8             7

B        4             9

I am using straight table to display the data and using Prod as dimension and 27-May and 3-Jun as as expressions.

When i load this data 27-May and 3-Jun will load as numbers and currently in label i'm manually writing the label as 27-May and 3-Jun.

How to make it dynamic. I mean whenever the 27-May and 3-Jun changes, i want the labels should be updated automatically.

I tried to use FieldName but didn't get the expected output.

Appreciate your help.

Regards,

Viresh

7 Replies

Re: how to display changing column headers in labels in straight table

Assuming date is the field name, may be this:

=Date(Max(Date), 'D-MMM') for 3-Jun

=Date(Max(Date, 2), 'D-MMM') for 27-May

vireshkolagimat
Contributor II

Re: how to display changing column headers in labels in straight table

Field name is 9-Mar and it is reading as number 42438. So the fieldname will chage again.

Re: how to display changing column headers in labels in straight table

Are you using CrossTable Load? Would you be able to share a sample?

vireshkolagimat
Contributor II

Re: how to display changing column headers in labels in straight table

No i am not doing cross table load. It's same table what i shared as sample.

Re: how to display changing column headers in labels in straight table

krishna_2644
Valued Contributor III

Re: how to display changing column headers in labels in straight table

Capture.PNG

This way?

vireshkolagimat
Contributor II

Re: how to display changing column headers in labels in straight table

Yes but square brackets are not required.

Community Browser