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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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

Labels (1)
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
MVP
MVP

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