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

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
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

Hi @DSDD ,

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

The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it