Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to use Total<> over a Calculated Dimension?

My calculated Dimension is say:

if( delivery_days > 6, delivery_date, '6+')

which I have renamed as say #Delivery

but when in an expression I write:

count( Distinct Order_id ) / count ( Distinct total<#Delivery> Order_id)

or

count( Distinct Order_id ) / count ( Distinct total<if( delivery_days > 6, delivery_date, '6+')> Order_id)

I just Don't get the result

0 Replies