Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikeers
Creator II
Creator II

Expression irrespective of selection

Where should I put "1" in this expression to make it completely irrespective to selections?

 

avg(Aggr( count( distinct
{<
Type={'M'},
%Id2 = {$(Var1)},

>} [ProId]), Day)
)

Labels (3)
1 Solution

Accepted Solutions
Digvijay_Singh

May be this - 

avg({1}Aggr({1} count({1} distinct
{<
Type={'M'},
%Id2 = {$(Var1)},

>} [ProId]), Day)
)

View solution in original post

2 Replies
Digvijay_Singh

May be this - 

avg({1}Aggr({1} count({1} distinct
{<
Type={'M'},
%Id2 = {$(Var1)},

>} [ProId]), Day)
)

qlikeers
Creator II
Creator II
Author

Thanks!