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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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