topic Re: Using Variable in bar chart in QlikView

Using Variable in bar chart

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Using Variable in bar chart

Anil_Babu_Samineni — Sat, 12 Aug 2017 00:50:10 GMT

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

Re: Using Variable in bar chart

veidlburkhard — Sat, 12 Aug 2017 09:38:47 GMT

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

Re: Using Variable in bar chart

wade12 — Sat, 12 Aug 2017 10:59:31 GMT

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