Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
KC3
Creator
Creator

How to get the total for Distinct Count as per order and Warehouse

Hi Team,

 

Please help me to get the total, i need the distinct count of order which was done as per ware house level.

I applied this formula but not getting the answer.

Sum(Aggr(Count(distinct{<[Sale Order Status New]={'DONE'},Facility_Updated>}),[Display Order Code]))

Sale Order Status New= If the order has been processed so from this i need only done data.

Facility Updated= Warehouse data

Display Order Code= Order Numbers

So i need the order count of Done as per warehouse means if 1 order has been went for 3 warehouse then the count will be 3.

Earlier i applied the formula for getting only Distinct count of display order code for sale order status new= done 

Count(distinct{<[Sale Order Status New]={'DONE'}>} [Display Order Code])

And i am getting the proper answer.

Please help me to get the Display order Code Count if Sale Order Status New]={'DONE'} and if the order has been split as per warehouse.

 

Need this soon please help me to get the answer

 

1 Reply
rubenmarin

Hi, you can try with:

Sum(Aggr(Count(distinct{<[Sale Order Status New]={'DONE'}>}),[Display Order Code],Facility_Updated))

Or:

Count(distinct{<[Sale Order Status New]={'DONE'}>} [Display Order Code]&'_'& Facility_Updated)