topic Selecting records within a chart in QlikView

Selecting records within a chart

Mon, 19 Mar 2012 16:07:36 GMT

Hi All, Hopefully this is an easy one and I am making a simple error. I am looking at Sales records and pre-selecting the date range. All works fine except I want to calculate a success rate based on a single logical field (scanned). I need to sum the sales value field for both records where this field is value = 1 and also where it is value = 0, then turn these two results into a % success rate to be displayed in a chart. My problem is that I cant see how to get the values SUM (sales value) where scanned = 0 and SUM (salesvalue) where scanned = 1. Any suggestions would be gratefully appreciated. Thanks in advance Mark

Selecting records within a chart

Tue, 20 Mar 2012 07:57:07 GMT

Hi, Try SUM({<scanned = {"0","1"}>} salesvalue) Cheers

Selecting records within a chart

Tue, 20 Mar 2012 09:45:07 GMT

Thanks for the help. I think I may have expressed myself badly in the question. i think this solution gives me a total for both possible values of scanned, i need to have two seperate totals for the SUM(salesvalue) so that I can present a % of all salesvalue that are scanned = 1.

Selecting records within a chart

CELAMBARASAN — Tue, 20 Mar 2012 09:52:23 GMT

Check with this

SUM({<scanned = {0}>} salesvalue) for scanned =0

SUM({<scanned = {1}>} salesvalue) for scanned =1

Celambarasan

Selecting records within a chart

Tue, 20 Mar 2012 20:02:13 GMT

Try

SUM({<scanned = {"0"}>} salesvalue) and SUM({<scanned = {"1"}>} salesvalue)