help with expression

Thu, 07 Nov 2013 07:49:18 GMT

Hi,

Hoping to duplicate a chart but be specific to each neighbourhood.

On the attached app you will see we have created 2 charts on 'sheet 2'. This currently shows the results based on the filter on first tab, however, we were hopig to create additonal charts that just show results for each neighbourhood so they are permanenlty on the app.

On the 1st chart - pie chart entitled 'Project Title -Eccles and Weaste' we have the following expression which enables the data to be presented in %'s. This is great but we want this chart just to show results from the neighbourhood 'Eccles and Weaste' - this expression doesn't do this...can you help?

([Time (decimal hours)])/Count(TOTAL [Time (decimal hours)])

On the 2nd chart - bar chart entitled 'Time (hours)' we have the following expression which enables the data to be presented in a simple bar chart. This is great but we again want this chart just to show results from the neighbourhood 'Eccles and Weaste' - this expression doesn't do this...can you help?

([Time (decimal hours)])

Eccles and Weaste is a neighbouhood, with list available on the main tab.

Really appreciate any help on this.

Re: help with expression

salto — Thu, 07 Nov 2013 08:04:09 GMT

Hi,

use set analysis. PFA my solution.

Hope this helps.

Re: help with expression

Thu, 07 Nov 2013 08:22:22 GMT

Thanks very muich..that's amazing and very helpful.

Cheers

Chris

topic help with expression in QlikView

help with expression

Re: help with expression

Re: help with expression