Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor III

Using Variable in bar chart

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.

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Using Variable in bar chart

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

View solution in original post

3 Replies
Highlighted

Re: Using Variable in bar chart

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Contributor III

Re: Using Variable in bar chart

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:Reusables.jpg

Hope this helps

Burkhard

Highlighted
Partner
Partner

Re: Using Variable in bar chart

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

View solution in original post