write count(if with set analysis

m_woolf — Wed, 21 Nov 2012 20:25:15 GMT

I have this expression:

count(if(InDateTime<=[30 min] and OutDateTime>=[30 min],LineNo))

which is working fine, but is a little slow. I thought maybe it would be faster with set analysis. I have tried:

=count({<InDateTime={'<=[30 min]'}> * <OutDateTime={'>=[30 min]'}>}LineNo)

and

=count({<InDateTime={'<=[30 min]'},OutDateTime={'>=[30 min]'}>}LineNo)

but no joy.

Re: write count(if with set analysis

Wed, 21 Nov 2012 22:42:22 GMT

count is a resource intensive function. You can use flags (set to 1 or 0) in the script to indicate if the LineNo is in a specific timebucket and then use those flags in your set analysis.

topic Re: write count(if with set analysis in QlikView

write count(if with set analysis

Re: write count(if with set analysis