topic Making a graph Static in Qlikview in QlikView

Making a graph Static in Qlikview

Wed, 23 Jul 2014 14:13:53 GMT

Hi Guys,

Really stuck will explain what im looking to do .

I wanted to have a graph and a table based on companies, so when I click on a company in a drop down it will show only those companies in the table, but the graph will remain the same.

I've tried detaching the graph but when I upload or save the detach doesn't stay, any suggestions really appreciated !

Thanks

Sarah

Re: Making a graph Static in Qlikview

Wed, 23 Jul 2014 14:18:20 GMT

In the chart's expression, try using {1} in your expression which should ignore selections. For example Sum({1} Sales)

Re: Making a graph Static in Qlikview

veidlburkhard — Wed, 23 Jul 2014 14:18:29 GMT

Hi Sarah,

you have to change the expression in your chart by means of set analysis and suppress the possible selection of companies by {$<company =>} ...

Burkhard

Re: Making a graph Static in Qlikview

cspencer3 — Wed, 23 Jul 2014 14:24:56 GMT

You could also put the Chart in an Alternate State, but then it would not be affected by any other selections unless they happen in the same state.

Re: Making a graph Static in Qlikview

Wed, 23 Jul 2014 14:33:47 GMT

Thanks Guys, so if I replace the current field which is called LeaseCo with {$<LeaseCo>} will that work or do I need to add this into the fomula somewhere

Re: Making a graph Static in Qlikview

Wed, 23 Jul 2014 14:41:48 GMT

Thanks for your help guys it works fine now