topic Re: Help in chart item in QlikView

Help in chart item

Tue, 03 Sep 2013 11:10:57 GMT

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.

Re: Help in chart item

Vegar — Tue, 03 Sep 2013 11:13:55 GMT

My first guess is that you have more than one Comment values associated with your dimensions. Try to use concat instead of only to investigate.

Concat(Comment, ', ')

Re: Help in chart item

rustyfishbones — Tue, 03 Sep 2013 11:14:25 GMT

Just say

=Comment

=ONLY(Comment) means it will only give you a result when one selection is made from the comment field

Re: Help in chart item

Tue, 03 Sep 2013 11:14:59 GMT

If you open up the "Comment" field in a selection box do you see any value?.

Try the formula "Maxstring"

Re: Help in chart item

Vegar — Tue, 03 Sep 2013 11:21:13 GMT

Alan Farrell: =Comment will give the same result as =Only(Comment) . You always aggregate in a Qlikview-expression and if no aggregation function is given then Qlikview assumes Only().

A good read on the topic isHenric Cronstr%c3%b6m blogpost QlikView Design Blog : It’s all Aggregations | QlikCommunity.

Re: Help in chart item

Tue, 03 Sep 2013 11:43:33 GMT

Thanks Very much it's working.

Re: Help in chart item

Tue, 03 Sep 2013 11:43:59 GMT

Thanks very much

Re: Help in chart item

Tue, 03 Sep 2013 11:46:33 GMT

How to use MaxString please let me know.

Thanks

Re: Help in chart item

Tue, 03 Sep 2013 12:22:50 GMT

You can merely do the following:

=Maxtring(Comments)

But you were looking for a different solution.

Maxstring is not always the safest formula to use and one must be careful what you are using it for.

If I have the following table maxstring will equal to Sep

=Maxstring() = Sep

Month

Month Desc

201308

Aug

201309

Sep

Re: Help in chart item

Tue, 03 Sep 2013 15:26:32 GMT

Hi,

Could you help me how to get the latest comment. Actually I have comments in the column from last year onwards. but I need the comment which is added on the day or atleast yesterday. Please help me how to use the expression.

Thanks.

Re: Help in chart item

Tue, 03 Sep 2013 16:15:02 GMT

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.