Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Highlighted
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)
mherdt1992
New Contributor

Re: qlikview calculation problem

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