Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
DSDD
Contributor III
Contributor III

Count despite/ignoring selection

Dear Community,

assume i have articles placed in several locations, like the following

DSDD_0-1613559492713.png

What i want is to calculate the distribution quota for each article.

That means i have to get the total number of locations (here 2, namely a and b):

DSDD_1-1613560147186.png

 

My problem is, that all suggestions for set analysis disregarding the selection are not working, like Count(distinct {1} location) or Aggr(...) or ..total...

I assume that the reason is, having article_no as dimension and having no connection between e.g. article_no 01 and location b in data model.

So how do i achieve to get the total count of locations?

Thanks for your help

 

Labels (1)
1 Reply
agigliotti
Partner - Champion
Partner - Champion

Hi @DSDD ,

Could you post a sample app with mock data and explaining what are you trying to achieve?