# QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements

Highlighted
New Contributor

## qlikview calculation problem

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.

1 Solution

Accepted Solutions
MVP

## Re: qlikview calculation problem

May be this

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

## Re: qlikview calculation problem

May be this

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

## Re: qlikview calculation problem

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

Community Browser