Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to add an expresion on the chart so that it only show certain records?
The chart shows void costs and tenancy costs for each property. We only want the chart to populate records where their is entry for both fields (([Completed Value]) and ([Cost])).
Was thinking this might be done is the calculated condition...?
Any assistance would be greatly appreciated.
Chris
Provide sample data file pls.
Yes this is possible..... Could you pl provide the qvw file
Try like this:
in the chart dimension > add calculated dimension > if([Completed Value]<>'' and [Cost]<>'',Dimension)
or
if(len([Completed Value])>0 and len([Cost])>0,Dimension)
The data is sensitive so added a test - see attached
you should add this filter to your expression, it the expression did not return any value the whole line will be removed.
Hi,
Do you put in the word 'dimension' or is this replaced?..only part of exprssion it doesnt' like.
Hi Chris,
Please find the attachment for the solution.