Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

mherdt1992
New Contributor

qlikview calculation problem

Dear all,

i have the following Problem.

neu3prop.PNG

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:

neuprob.PNG

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

Re: qlikview calculation problem

May be this

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

Re: qlikview calculation problem

May be this

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

Re: qlikview calculation problem

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