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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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