restrict data showing on a chart

[#1]

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

[MK_QSL]

Provide sample data file pls.

[#3]

Yes this is possible..... Could you pl provide the qvw file

[avinashelite]

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)

[#5]

The data is sensitive so added a test - see attached

[maleksafa]

you should add this filter to your expression, it the expression did not return any value the whole line will be removed.

[#7]

Hi,

Do you put in the word 'dimension' or is this replaced?..only part of exprssion it doesnt' like.

[avinashelite · Accepted solution]

Hi Chris,

Please find the attachment for the solution.