topic Problem with exclude in Set in QlikView

Problem with exclude in Set

Thu, 15 Mar 2012 16:25:33 GMT

Can anyone se why the exclude FR don´t work in this set?

=Count({$<Insats.SCBKOD={">=13<18"}>}{<Insats.INSATSGRP1-={'FR'}>}{<Insats_Inledd={$(=Chr(39)&Concat(Distinct Datum ,Chr(39) & ',' & Chr(39)) & Chr(39))}>} DISTINCT INSATSID)

It´s just like it overrule it becuase it presents the same as with out...

/THanks!

Problem with exclude in Set

swuehl — Thu, 15 Mar 2012 17:48:28 GMT

Each {<...>} is defining a set. I don't believe that you can use set analysis with three sets like above, I think only the last set will actually be used.

Why not use one set with a set modifier with all three fields:

=Count({$<Insats.SCBKOD={">=13<18"}, Insats.INSATSGRP1-={'FR'}, Insats_Inledd={$(=Chr(39)&Concat(Distinct Datum ,Chr(39) & ',' & Chr(39)) & Chr(39))}>} DISTINCT INSATSID)