Filter in Chart Totals

Wed, 10 Jun 2009 23:04:26 GMT

Hi,

I have a set of data imported from SQL which looks like this:

FileName FileSize Summed

CP 1000 1

VP 2000 1

CP2 100 0

I want to display the data in a chart, so that when each file name is selected it shows the appropriate file size (easy), but where nothing is selected in the filter only the sizes where the Summed Column is 1 should be totalled. So in the case above the total file size would be 3000 (the CP2 file size is not summed, so not included in the total).

I have tried various If statements in the Expression but with no luck. Can anyone help?

Filter in Chart Totals

rwunderlich — Thu, 11 Jun 2009 03:00:58 GMT

Assuming your Summed values are always 1 or 0, you've got a builtin Oleg-style flag to use. How about an chart expression like:

sum(if(GetSelectedCount(FileName) > 0, FileSize, FileSize * Summed))

-Rob

topic Filter in Chart Totals in QlikView

Filter in Chart Totals

Filter in Chart Totals