Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

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

View solution in original post

4 Replies
nathanfurby
Specialist
Specialist

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_Michaelides
Luminary Alumni
Luminary Alumni

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

Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Author

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!