Set Analysis - And statement for same field

Wed, 23 Jan 2013 15:53:44 GMT

I am trying to write a set analysis for our consumers who are on 6 or more medications and 10 or less medications (i.e. taking anywhere from 6 - 10).

This is my expression so far:

Count( {<Year=,Month=,[Medications Total]={'>=6'},[Medications Total]={'<=10'}>} _ConsumerProfileKey)

I want year and month to be null so that's taken care off.

This expression is only giving me consumers who are taking 10 or less medications and is disregarding the 6 or more condition. Is there another way of writing this a different way?

I've spent the last hour with no success

Re: Set Analysis - And statement for same field

Gysbert_Wassenaar — Wed, 23 Jan 2013 15:55:55 GMT

Have you tried this:

Count( {<Year=,Month=,[Medications Total]={">=6<=10"}>} _ConsumerProfileKey)

Re: Set Analysis - And statement for same field

Wed, 23 Jan 2013 15:57:55 GMT

Worked perfectly. Thank you so much!

topic Re: Set Analysis - And statement for same field in QlikView

Set Analysis - And statement for same field

Re: Set Analysis - And statement for same field

Re: Set Analysis - And statement for same field