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: 
vireshkolagimat
Creator III
Creator III

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
sunny_talwar

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
Creator III
Creator III
Author

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

sunny_talwar

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

vireshkolagimat
Creator III
Creator III
Author

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

settu_periasamy
Master III
Master III

krishna_2644
Specialist III
Specialist III

Capture.PNG

This way?

vireshkolagimat
Creator III
Creator III
Author

Yes but square brackets are not required.