Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Problem with exclude in Set

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!

1 Solution

Accepted Solutions
swuehl
Not applicable

Problem with exclude in Set

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)

1 Reply
swuehl
Not applicable

Problem with exclude in Set

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)