Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Last date with data formula required

Hi,

I want to create a variable which is the date at which a particular product ends.

For example if the sale of Product XYZ ended in Dec 2012 while the financial year ends in April 2013, what function could I use?

thanks in advance

C

3 Replies
Gysbert_Wassenaar

Try: max({1<Product={'XYZ'}>} MyDate)


talk is cheap, supply exceeds demand
Not applicable
Author

Thanks Gysbert.

This is kind of what I need however, the month Jan to April have zero's in them therefore the mas date being picked up is still April 2013 not Dec 2012.

I know I need to use set analysis in some way but not sure of the syntax.

=max({sum of the data is <> 0} Date)

Gysbert_Wassenaar

max({1<Product={'XYZ'},SalesAmount-= {0}>} MyDate). The -= is correct even though the expression editor flags it as wrong with a red line. Change SalesAmount with the name of the field that has the 0 values.


talk is cheap, supply exceeds demand