Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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, ', ')
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, ', ')
Just say
=Comment
=ONLY(Comment) means it will only give you a result when one selection is made from the comment field
If you open up the "Comment" field in a selection box do you see any value?.
Try the formula "Maxstring"
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.
Thanks Very much it's working.
Thanks very much
How to use MaxString please let me know.
Thanks
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
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.