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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

set analysis help

I have the expression as

=count({$<Delay_Month_Convert={">=$(=Timestamp(MonthStart(AddMonths(Today(), -6)), 'DD/MM/YYYY h:mm:ss[.fff] TT'))<$(=Timestamp(MonthStart(Today()), 'DD/MM/YYYY h:mm:ss[.fff] TT'))"}>}distinct External_HU)/ HU_Count

what I am trying to get is a %age of delayed units/ total units loaded

So my second part of my expression should have a set analysis as (Delay_month_convert = Load_month) then use Hu_count for division

0 Replies