Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

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
Highlighted
Partner
Partner

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

Highlighted
Master II
Master II

Just say

=Comment

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

Highlighted
Not applicable

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

Try the formula "Maxstring"

Highlighted
Partner
Partner

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
Highlighted
Not applicable

Thanks Very much it's working.

Highlighted
Not applicable

Thanks very much

Highlighted
Not applicable

How to use MaxString please let me know.

Thanks

Highlighted
Not applicable

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

Highlighted
Not applicable

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.