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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
risabhroy_03
Partner - Creator II
Partner - Creator II

Set analysis

I want to convert my below statement in set analysis

if([Invoice_Date_GMT_Updated]=date(max(total <[Company_Code]> [Invoice_Date_GMT_Updated])),

sum(Quantity),

null()

)

 

I wrote this 

Sum({<[Invoice_Date_GMT_Updated]={'=floor(num(date(max(total <[Company_Code]> [Invoice_Date_GMT_Updated]))))'}>}Quantity)

 

But extra rows are also coming.

 

Please help.

0 Replies