Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
davyqliks
Specialist
Specialist

How to ignore a dimension in an Aggr(count)

HI,

I have an Aggr count expression which is giving me a wrong number due to duplications being created by a related field.

i have tried the below after some reading.

aggr(Count (total {<Standards =- {'Non-Applicable Standards'}, portal_order_no=>} standard_name),parent_name)

There are multiple portal_order_no for each standard name so i wish to ignore portal_order_no data in the count.

 

Please can anyone give some advise on how this can be achieved?

 

thank you

 

Daniel

 

 

Labels (2)
3 Replies
sidhiq91
Specialist
Specialist

@davyqliks  Could you please give me some sample data and expected results?

davyqliks
Specialist
Specialist
Author

Thank for the reply,

I have exported the table to excel to access the situation on a smaller scale.

in the below i need to count the Standard names(not including the ticks) and only one per production facilty.

So the count should be 5 on a single line where as i am getting 10.

Looking at the below i do not need to ignore the portal order number, however i cannot get the number i need.

 

Thank you for your help in advance.

 

davyqliks_0-1659692340578.png

 

davyqliks
Specialist
Specialist
Author

Hi experts,

Is anyone able to assist, i am going round in circles trying to get t he correct result. From the image previously attached i need to achieve a count total on a single line of 5 and i can only get 10 based on the below expression:

aggr(
Count ({<Standards =- {'Non-Applicable Standards'}>} standard_name),parent_name)

 

I did manage to get the desired 5 by using the following however, this was on every line, and when i unfiltered the total count for all was on every line.

 

Thank you in advance if anyone is able to assist, 

 

Daniel