qlikview calculation problem

[mherdt1992]

Dear all,

i have the following Problem.

In this Picture, the following calculation gives these results :

=COUNT (  { < S.Termin={"0"},vkselbst ={'VKyes'} > } DISTINCT KNneu) = 1

=COUNT (  {< S.Termin={"0"}, vkselbst ={'VKno'},spselbst={'SPyes'} > } DISTINCT KNneu) = 0

Which is correct.

Now if i select more Months:

I get for the same Formulas :

=COUNT (  { < S.Termin={"0"},vkselbst ={'VKyes'} > } DISTINCT KNneu) = 1

=COUNT (  {< S.Termin={"0"}, vkselbst ={'VKno'},spselbst={'SPyes'} > } DISTINCT KNneu) = 1.

The Second Formula is wrong.

What i want is, if "VKyes" appears in the list and spselbst is "SPyes" , then return 0. Only if the hold list contains "VKno" and anywere  "SPyes" then return 1.

This is a imported Excel List. No Calculations in the presented Table.

[sunny_talwar · Accepted solution]

May be this

=Count({<
  S.Termin={"0"},
  KNneu = e({<vkselbst = {'VKyes'}>},
  spselbst = {'SPyes'}
>} DISTINCT KNneu)

[mherdt1992]

I have to check it, but seems to be correct. Thank you very much Sir !