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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
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