Store count needed over a condition

Tue, 31 Jan 2017 06:44:50 GMT

Dear all,

I have used an expression to display stores for which data is not sync as follows:

In a straight table i have used this expression to display stores for which data is not sync where my dimension is "Site"

if(num(If((Date(Today()-1,'DD/MM/YYYY'))-(MaxString({1<Month=,Year=,@_TABLE={'T1'}>}%_TARNDATE))<15,

Date(Today()-1,'DD/MM/YYYY')))

-num(If((Date(Today()-1,'DD/MM/YYYY'))-(MaxString({1<Month=,Year=,@_TABLE={'T1'}>}%_TARNDATE))<15,

MaxString({1<Month=,Year=,@_TABLE={'T1'}>}%_TARNDATE)))>0,

num(If((Date(Today()-1,'DD/MM/YYYY'))-(MaxString({1<Month=,Year=,@_TABLE={'T1'}>}%_TARNDATE))<15,

Date(Today()-1,'DD/MM/YYYY')))

-num(If((Date(Today()-1,'DD/MM/YYYY'))-(MaxString({1<Month=,@_FinFullYear=,@_TABLE={'T1'}>}%_TARNDATE))<15,

MaxString({1<Month=,Year=,@_TABLE={'T1'}>}%_TARNDATE))))

This expression is working fine

now in a text object I want to count this stores:

count of stores where this condition is applied.

Please help.

topic Store count needed over a condition in QlikView