Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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 II
Champion II

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

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 II
Champion II

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

View solution in original post

bbmmouha
Creator
Creator
Author

thank you

i learned something new 

bbmmouha
Creator
Creator
Author

thank you

vinieme12
Champion II
Champion II

Glad to help

Cheers

V