Skip to main content
Announcements
Get Ready. A New Qlik Learning Experience is Coming February 17! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Store count needed over a condition

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.

0 Replies