Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
berkarmagan
Partner - Creator
Partner - Creator

Aggr set analysis problem

Hi everyone,

I ve a pivot table like example below. I ve got region, country, products and calculated dim as VisitDim. Sales and Visit on expression. My problem is visit data isnt related with products. I mean in expression i cannot split visit calculation by products. On calculated dimension i got true answer with this;

=AGGR(COUNT({<Products=>}DISTINCT CustomerID), Region, Country)

But when i put this on expression it doesnt work properly, first of all "Products=" make it trouble, selection on products doesnt work because of this.

How should i make my expression to get the same result like VisitDim. By the way can i use calculated dimension on expression with any column(columnno) function or sth like that? If not pls share your suggests about expression.

Thanks for now.

 

ProductsABC
RegionCountryVisitDimSalesVisitSalesVisitSalesVisit
mx51035 55
my205 0
mz750 7
nf102 0
nt260 0
1 Reply
marcus_sommer

It's quite the same like: Pivot Table total func problem

- Marcus