Set Analysis -vs- sheet properties

josephinetedesc — Wed, 22 Feb 2017 05:17:57 GMT

I thought I would share this:

I had a sheet where I made some fields "mandatory" using the Settings- Sheet Properties-Triggers and from here I set the Select In Field.

I then had a number of formulas like this with the "mandatory" settings specified again.

Sum({$<Classification = {'Clinical'},IsHoliday = {'0'},IsWeekEnd = {'Remove Saturdays'}>}DurMins)

There was then a week of 0 values (ie Classification was NULL) and the figures were incorrect.

I then deleted the mandatory sheet settings but kept the formulas and the figures were correct.

so BEFORE: I could see what the selections were in the Current Selections Box

but now I cannot. Is there a way of displaying the SET ANALYSIS values?

This qvw file will show what I mean regarding the Current Selections box

Message was edited by: Jo Tedesco

topic Set Analysis -vs- sheet properties in QlikView