Qlik Community

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 
Search instead for 
Did you mean: 
Highlighted
Contributor
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
Highlighted

May be this

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

View solution in original post

2 Replies
Highlighted

May be this

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

View solution in original post

Highlighted
Contributor
Contributor

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