topic Set Analysis question in QlikView

Set Analysis question

Mon, 19 Sep 2011 15:56:27 GMT

Bit of background...

I have a set of data that included 4 fields that indicate if data has been modified in the table. I want to be able to chart five different buckets: No mods made, 1 mod made, 2 mods made, 3 mods made, and 4 mods made. I don't necessarily care to indicate WHICH field was modified, just the number of the fields that were modified. Is there a way to accomplish this?

Thanks!

Set Analysis question

nathanfurby — Mon, 19 Sep 2011 16:13:43 GMT

You could evaluate the 4 fields in the load script and assign a 0-4 in a new count field. Could then sum up this new field in the chart - and also do the grouping.

Set Analysis question

Jason_Michaelides — Mon, 19 Sep 2011 17:19:45 GMT

What are the possible values of the modified? field? Yes/No, 1/0, Modified/Null()??

Set Analysis question

Oleg_Troyansky — Mon, 19 Sep 2011 18:33:45 GMT

Assuming that your 4 fields are 1/0 flags, when 1 signifies a change, I'd recommend creating a calculated dimension as a summary of all 4 fields:

RANGESUM(Fld1, Fld2, Fld3, Fld4, Fld5)

In the expression, simply count the unique keys that identify your data:

count(distinct UniqueID)

This should do what you described...

cheers,

Oleg

Set Analysis question

Wed, 21 Sep 2011 20:10:15 GMT

This did the trick, well mostly. My fields weren't 1/0 flags, so instead of RANGESUM(Fld1, fld2, fld3, fld4) I used RANGESUM(if(fld1='None', 0, 1), ...)

Thanks!