# QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for
Did you mean:
Highlighted 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
Highlighted MVP

May be this

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

May be this

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

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