Using Variable in bar chart

[Anonymous]

Hi all,

I have the below expression in a bar chart. Is it possible to store this in a variable and use it for multiple charts.

"=if(GetFieldSelections(Properties)='WithoutProperties'and GetFieldSelections(Reusability)='Output', count(DISTINCT {<BOFF={'Y'}>} OutputWithoutProperty),

if(GetFieldSelections(Properties)='WithProperties'and GetFieldSelections(Reusability)='Output', count(DISTINCT {<BOFF={'Y'}>} OutputWithProperty),

if(GetFieldSelections(Properties)='WithoutProperties'and GetFieldSelections(Reusability)='Input', count(DISTINCT {<BOFF={'Y'}>} InputWithoutProperty),

if(GetFieldSelections(Properties)='WithProperties'and GetFieldSelections(Reusability)='Input', count(DISTINCT {<BOFF={'Y'}>} InputWithProperty),

if(GetFieldSelections(Properties)='WithoutProperties'and GetFieldSelections(Reusability)='Both', count(DISTINCT BothWithoutProperty),

if(GetFieldSelections(Properties)='WithProperties'and GetFieldSelections(Reusability)='Both', count(DISTINCT BothWithProperty)))))))"

Please help. Also attached the QVW file.

Thanks,

Siva.

[Anil_Babu_Samineni]

May be store without double quotes and check in your hand then tell us whether where you are getting issue.

[veidlburkhard]

Hi siva,

you simply copy your expression into an input box as a new variable.

Please don't use an equal sign.
See the picture below:

Hope this helps

Burkhard

[wade12 · Accepted solution]

settings -> variable overview -> add new variable -> paste in definition (no equal sign or quotes)