Help in chart item

[#1]

Hi,

I have one qlikview file and all is fine. But I have one straight table chart item. and this chart tiem is picking data from Link Table(combination of three tables). I have one coulmn 'COMMENT'. the expression I used to get data into this column is

=Only(Comment)

and this Comment data is coming from access table. In the database it is showing column values. but in the qlikview file it is showing blank values. Could anyone help me in this please.

Thanks.

[#2]

You would then need to say the following.

=Maxstring({<Day={$(vLatest_Day)}>}Comments)

The variable “vLatest_Day” must be created as the following

Let vLatest_Day=max(day);

The day in here must be replaced by your own day field.

This result will only show the very latest Comments.