topic Boolean Functions in Set Analysis? in QlikView

Boolean Functions in Set Analysis?

Jason_Michaelides — Mon, 14 Mar 2011 15:38:58 GMT

Hi all,

I have the following expression in a pivot table:

=SUM(IF(InMonthToDate(Date,Today()-1,0) AND [Calc Ad?]='YES',Impressions))

To improve efficiency I want to convert this to a Set Analysis expression but can't see how. Any ideas?

Thanks,

Jason

Boolean Functions in Set Analysis?

Oleg_Troyansky — Mon, 14 Mar 2011 16:40:39 GMT

If Date (or Month, or anything Date-related) needs to be one of your Chart Dimensions, than you can't use Set Analysis - because Set Analysis is only calculated once for the whole chart.

Also, I'd recommend to simplify the condition InMonthToDate() and pre-calculate a flag in your load script: MTDFlag=1 for all dates in your calendar that satisfy this condition.

Then, if your chart doesn't have a date as a dimension, you can do something liket his:

sum({<MTDFlag={1], [Calc Ad?]={'YES'} >} Impressions)

Boolean Functions in Set Analysis?

Jason_Michaelides — Thu, 17 Mar 2011 10:35:49 GMT

Many thanks Oleg.