topic Re: count if x = O or Y= O in QlikView

count if x = O or Y= O

bbmmouha — Sun, 23 Apr 2017 08:35:15 GMT

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

ElizaF — Sun, 23 Apr 2017 09:47:40 GMT

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 — Sun, 23 Apr 2017 09:52:28 GMT

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

For other similar problems, see my reply on this post

bbmmouha — Sun, 23 Apr 2017 11:30:16 GMT

thank you

i learned something new

bbmmouha — Sun, 23 Apr 2017 11:31:36 GMT

thank you

vinieme12 — Sun, 23 Apr 2017 11:32:39 GMT

Glad to help

Cheers