Issue_2

[Mahamed_Qlik]

[anat]

count({<beftid={'59','56'}>}distinct id)

[pravinboniface]

Please try this for the measure.

If you want to see only the highlighted rows, please deselect 'Include Zero Rows' under Data Handling.

if (
    Count({<BNFT_ID={'59'}>}distinct CIVIL_ID) +
    Count({<BNFT_ID={'56'}>}distinct CIVIL_ID) =2,
    1,0)

[Mahamed_Qlik]

Hi

I have tried as below:

Count({<SL_Month={"=below(SL_Month)"},CIVIL_ID= P({<BNFT_ID={'56'},SL_Month={"=below(SL_Month)"}>} CIVIL_ID)*P({<BNFT_ID={'59'},SL_Month={"=below(SL_Month)"}>} CIVIL_ID)
>} distinct CIVIL_ID)

it is returning correct result in but when I select SL_month in filter it is showing as 0(zero)