Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Not applicable

Help in chart item


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.

1 Solution

Accepted Solutions
Partner
Partner

Re: Help in chart item

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, ', ')

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

10 Replies
Partner
Partner

Re: Help in chart item

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, ', ')

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

rustyfishbones
Honored Contributor II

Re: Help in chart item

Just say

=Comment

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

Not applicable

Re: Help in chart item

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

Try the formula "Maxstring"

Partner
Partner

Re: Help in chart item

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.

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Not applicable

Re: Help in chart item

Thanks Very much it's working.

Not applicable

Re: Help in chart item

Thanks very much

Not applicable

Re: Help in chart item

How to use MaxString please let me know.

Thanks

Not applicable

Re: Help in chart item

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

Not applicable

Re: Help in chart item

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.