qlikview calculation problem

mherdt1992 — Wed, 30 Jan 2019 14:57:15 GMT

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.

Re: qlikview calculation problem

sunny_talwar — Wed, 30 Jan 2019 15:07:16 GMT

May be this

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

Re: qlikview calculation problem

mherdt1992 — Wed, 30 Jan 2019 16:45:33 GMT

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

topic Re: qlikview calculation problem in QlikView

qlikview calculation problem

Re: qlikview calculation problem

Re: qlikview calculation problem