Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bbmmouha
Creator
Creator

count if x = O or Y= O

hello

i have a little problem i have three table

table tiers ; cod_tiers , age , nom , prenom

table presence ; cod_tiers , present ( yes , no , null )

table vote ; cod tiers , vote ( yes , no , null )

what i want is count cod_tiers if present = yes or vote = yes

i tried this but it is incorrect =count({<VOTE={'O'},PRESENCE={'O'}>} COD_TIERS) this give me present = yes and (not or ) vote = yes

thank you for your answer in advance

1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

Count({<PRESENT={'YES'}>+<VOTE={'YES'}>} DISTINCT COD_TIERS)


For other similar problems, see my reply on this post


Re: Nested Set Analysis - Customer bought in both time periods

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

5 Replies
ElizaF
Creator II
Creator II

Hello,


Try the expression:

Count({$<COD_TIERS=P({1<PRESENT={'YES'}>}COD_TIERS),

                COD_TIERS=P({1<VOTE={'YES'}>}COD_TIERS)

      >}COD_TIERS)

Also, for the performance of the app, I recommend a single FACT table with the necessary data. See the attached file.

vinieme12
Champion III
Champion III

Count({<PRESENT={'YES'}>+<VOTE={'YES'}>} DISTINCT COD_TIERS)


For other similar problems, see my reply on this post


Re: Nested Set Analysis - Customer bought in both time periods

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
bbmmouha
Creator
Creator
Author

thank you

i learned something new 

bbmmouha
Creator
Creator
Author

thank you

vinieme12
Champion III
Champion III

Glad to help

Cheers

V

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.