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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Expression help

Hi All,

i want to add some bucketing in my expression ..

This is my expression

SUM({$<FinancialYear=,Quarter=,MonthName=,[Date] ={"<=$(=MonthEnd(Max([Date])))"}>}[Sale])

And I want to add below condition in above expression

=if((num((num(vDateForAgeing)-[Post Date ]),'#######0') )<=180 ,'Below Six Month',

if(num((num(vDateForAgeing)-[Post Date ]),'#######0')>=180.1,'Above 181',

0))

Thanks

12 Replies
Anonymous
Not applicable
Author

Hi All,

I need Bucket ageing sale for above 6 six month and Below Six month....

Thanks

Anil_Babu_Samineni

Bucket Creation In List Box

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anonymous
Not applicable
Author

I have created like this but i want in this as expression

Like in my one repression I want sum(sale) in 2nd expression sum(actual sale < 180 days ) and 3rd expression sum(actual Sale > 180 days)

Thanks