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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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