Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day,
wanted to find out if its possible to hide a chart table when no selections have been made,
basically i do not want the error "Out of object memory" to be displayed or to even allow Qlkivew to reach a point that the error "Out of object memory" is displayed. I want Qlikview to only start displaying information on the chart table once selections have been made. if no selections are made then the chart should simple state "Make Selections".
regards
Attached is an example that you can take a look and build according to your needs. Hope this helps:
Instead of hiding the chart, I suggest you add a Calculation Condition to the chart. This can be done on the General tab.
Next you can change the Error Message of the calculation condition to tell your user what he/she should do in order to get results on the chart.
Expanding on the above you might not want to let the chart get to the error stage as it might take some time for it to calculate to get to that point.
In that case I would add a show condition to the chart (layout tab) to hide the chart and put the opposite logic on a text object which tells the users what to do.
For example:
to hide if no selections have been made in a field: GetSelectedCount(fieldname) > 0
to hide if you want to only show when say 10,000 rows are available: getpossiblecount(countfield) <10,000
Adam,
Hiding the chart is fine but Onno's suggestion is solid as well. The calculation condition will be evaluated before an attempt is made to calc the chart -- so no error stage will be reached.
It's a bit confusing that the message for "Calculation condition unfufilled" is under the Error Message button. It's not really an "error", but that's the nomenclature.
-Rob
I totally agree with Rob: Calling that text an "Error Message" is very confusing indeed .
Adam Davies wrote:
For example:
to hide if no selections have been made in a field: GetSelectedCount(fieldname) > 0
to hide if you want to only show when say 10,000 rows are available: getpossiblecount(countfield) <10,000
I suggest instead of putting those examples in the Hide Condition, to put them in the Calculation Condition.
Attached is an example that you can take a look and build according to your needs. Hope this helps:
Hi Pusho,
this should resolve your issue.
In the property of your chart >>>Layout and on the layout page you will find Show.
Set the Show to Conditional and in the box type len(GetCurrentSelections())<>0
Now the chart will show only if there is a selection.
Sorry I didn't mean in any way that Onno's suggestion wasn't valid and indeed it is in true terms the 'correct' way to handle things.
However sometimes it is easier to make things a little more obvious and 'in your face' for users which I don't think those "error" messages always are, so was purely presenting an alternative.
This is one of the reasons why I like Qlik, there are many different ways to do things depending on the situation and you know you'll always get a healthy debate on the best method
Thank you all, i resolved my issue by adding the Calculation Condition