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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
asifmaula2015
Contributor
Contributor
‎2015-09-23 09:26 AM

Set Analysis Problem

I want to convert this below expression into a set expression:

(sum(if(PERIOD='QTD' and FISCAL_QUARTER=SELECTED_QUARTER and DATE_KEY<=DATE AND SOURCE_FLAG='ORDERS',SALESNETAMOUNT,0))-sum(if(PERIOD='QTD' and FISCAL_QUARTER=SELECTED_QUARTER-10 and DATE_KEY<=AddYears(DATE,-1) AND SOURCE_FLAG='ORDERS',SALESNETAMOUNT,0)))/
sum(if(PERIOD='QTD' and FISCAL_QUARTER=SELECTED_QUARTER-10 and DATE_KEY<=AddYears(DATE,-1) AND SOURCE_FLAG='ORDERS',SALESNETAMOUNT,0))*100

Can anyone help me on this?

Thanks in Advance

Asif

313 Views
0 Likes
0 Replies