topic Re: Why is set analysis condition ignored? in QlikView

Why is set analysis condition ignored?

Thu, 06 Nov 2014 11:36:56 GMT

In the below formula the conditions highlighted in yellow are ignored by QV, ie. Apples, Oranges and Plums are included though they shouldn't. Lemons are correctly excluded. I guess I should write it in another way but don't know how.

Would anyone help please so that all set analys conditions are adhered to?

Count(DISTINCT {$<SavedReport={'New'},TaskProductName-={'Apples'},TaskProductName-={'Oranges'},TaskProductName-={'Plums'},TaskProductName-={'Lemons'},$(vCalendarFields)>}TaskID)

Re: Why is set analysis condition ignored?

MK_QSL — Thu, 06 Nov 2014 11:39:22 GMT

Count(DISTINCT {$<

SavedReport={'New'},

TaskProductName-={'Apples','Oranges','Plums','Lemons'},

$(vCalendarFields)>}TaskID)

Re: Why is set analysis condition ignored?

tresB — Thu, 06 Nov 2014 11:40:34 GMT

To exclude multiple values from a single field try like:

TaskProductName-={'Apples', 'Oranges', 'Plums', 'Lemons'}

Re: Why is set analysis condition ignored?

Thu, 06 Nov 2014 11:45:56 GMT

Thank you both for your answers! That did the trick.