topic Set Analysis Expression in QlikView

Set Analysis Expression

Mon, 14 Jul 2014 12:52:39 GMT

Hello,

I have the following Set Analysis:

COUNT(DISTINCT ACCOUNT_ID)

COUNT({1<ACCOUNT_ID>}DISTINCT ACCOUNT_ID)

What I want is to add this (the underlined) to both COUNT functions:

COUNT ({$<ID_TIE_DATE#={">=$(='$(vDateFrom)')<=$(='$(vDateTo)')"}>} DISTINCT ACCOUNT_ID)

Do you know how could I do it?

Thank you!

its_anandrjs — Mon, 14 Jul 2014 12:59:57 GMT

Try with

COUNT ( {$< ID_TIE_DATE# = { " >= $(vDateFrom) <= $(vDateTo) " } >} DISTINCT ACCOUNT_ID)

Mon, 14 Jul 2014 13:04:39 GMT

Thanks, but how do I apply the ID_TIE_DATE# over the 2nd COUNT?

COUNT ({$<ID_TIE_DATE#={">=$(='$(vDateFrom)')<=$(='$(vDateTo)')"}>} DISTINCT ACCOUNT_ID)

COUNT({1<ACCOUNT_ID>}DISTINCT ACCOUNT_ID)

its_anandrjs — Mon, 14 Jul 2014 13:12:50 GMT

Try

COUNT ( {$< ID_TIE_DATE# = { " >= $(vDateFrom) <= $(vDateTo) " } >} DISTINCT ACCOUNT_ID)

COUNT( {1<ACCOUNT_ID=, ID_TIE_DATE# = { " >= $(vDateFrom) <= $(vDateTo) " } >} DISTINCT ACCOUNT_ID)

What is your expected output?

Mon, 14 Jul 2014 13:23:32 GMT

Thank you, I think this worked!

I was expecting to show a relative % considerating the ID_TIE_DATE# field from my Master Calendar.