topic Re: chart drill through in QlikView

chart drill through

rcorcoran — Mon, 20 Apr 2015 10:46:57 GMT

another query on a chart.

The chart attached is showing data this year v previous 2 years but it is showing a total for all areas.

I need it to show total for each area if they are selected from the area list box.

Any help appreciated

rubenmarin — Mon, 20 Apr 2015 10:57:00 GMT

Hi R, you can add a TOTAL clause per RDODesc and remove the {1} that ignores all selections, ie:

=Sum(TOTAL <RDODesc> {<[ImmVacc 117] ={12},ReferredYYYY={'$(=Max(ReferredYYYY)-1)'}>}ActualValue)

sunny_talwar — Mon, 20 Apr 2015 11:00:40 GMT

Your expression: =Sum({1<[ImmVacc 117] ={12},ReferredYYYY={'$(=Max(ReferredYYYY))'}>}ActualValue)

and [ImmVacc 117] seems to be blank in 2015 and you are using the set analysis statement to include only [ImmVacc 117] which equal 12.

Otherwise to let your selections in Area work you can do something like this:

=Sum({1<[ImmVacc 117] ={12},ReferredYYYY={'$(=Max(ReferredYYYY))'}, RDODesc = p(RDODesc)>}ActualValue)

HTH

Best,

Sunny

rcorcoran — Mon, 20 Apr 2015 11:08:25 GMT

Thanks Sunindia that works great

sunny_talwar — Mon, 20 Apr 2015 11:13:22 GMT

I am glad it worked.

Best,

Sunny