Is there a way to avoid selecting with the values populated in the dimension

[varunreddy]

Hi Guys,

I am trying to build a bar chart with two dimensions (Date and organisation). Is there a way that I can show the organisation but restrict selections for the organisation.

Thanks in advance.

Regards,

Varun Reddy. K

[alexandros17]

If for example organization is composed by A,B,C and D values and you do not want to show B then write in the

"calculated dimension"

If(Organization = 'B', Null(), Organization)

then check the box "Suppress when value is null"

let me know

[jonathandienst]

I don't really understand your question. Do you want to see all organisations on the chart regardless of organisation selections? Then use a set expression like

     Sum({<organisation=>} Amount)

Otherwise, I suggest you upload your qvw or a representative sample to explain your question more clearly.

[sunny_talwar]

within your expression just add this as a set analysis:

{<Organisation = >}

[swuehl · Accepted solution]

You can change the chart to read-only on general tab of chart properties.

User won't be able to select dimension values within the chart then (also no selection of dates).

[varunreddy]

Swuehl,

Is there a way to select Dates and restrict Organisation?

Regards,

Varun