Solved: Problem with exclude in Set - Qlik Community

Report Inappropriate Content · ‎2012-03-15

Hi

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!

swuehl · ‎2012-03-15

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)

View solution in original post

swuehl · ‎2012-03-15

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)