Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Set Analysis question

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!

1 Solution

Accepted Solutions
MVP
MVP

Set Analysis question

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

4 Replies
nathanfurby
Valued Contributor

Set Analysis question

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.

jason_michaelid
Honored Contributor II

Set Analysis question

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

MVP
MVP

Set Analysis question

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

Not applicable

Set Analysis question

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!

Community Browser