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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
aheavy95
Creator
Creator
‎2022-05-16 09:44 AM

calculate distinct apearences of a dimension in a dimension

Hi all

I want to calculate how many distinct products are in one order (preferably an app calculation, not in script).

SalesOrderID- an entire order

SalesOrderDetailID  - "mini order"of one productinside the order with info about the qty etc

How can I find out how many different products are in one SalesOrderID?

thanks 

Labels (2)
Labels
525 Views
0 Likes
3 Replies
vinieme12
Champion III
Champion III
‎2022-05-17 05:51 AM

count(distinct Products)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
496 Views
0 Likes
aheavy95
Creator
Creator
‎2022-05-17 10:20 AM
Author

I need a calculation that is per salesorderID 

490 Views
0 Likes
vinieme12
Champion III
Champion III
‎2022-05-17 11:49 AM

In response to aheavy95

What is your chart Dimension?

What exactly are you trying to create?

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
486 Views
0 Likes