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
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
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: 
vikasmahajan
MVP
MVP
‎2014-01-09 02:42 AM

How to use this expression in calculate dimension

Dear All,

I have following expression & I want to use this in calculated dimension how do I use in calculated dimension

=(SUM({<FinancialYear=,Quarter=,MonthName=>} AGGR(if( (Date(vDateForAgeing)-if(isnull(Date([DUE_DATE])),1,Date([DUE_DATE])) <=30),SUM({$<FinancialYear=,Quarter=,MonthName=,[Posting Date] ={"<=$(=MonthEnd(Max([Posting Date])))"}>}[Net Outstanding])),DOC_NO,Customer,Location))

/100000)

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
1,166 Views
0 Likes
10 Replies
Not applicable
‎2014-01-09 05:15 AM

In response to vikasmahajan

Scramble the data and share it

http://community.qlik.com/docs/DOC-4032

http://community.qlik.com/docs/DOC-1290

124 Views
0 Likes