Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Sunil_Kenth
Former Employee
Former Employee

Chart showing sales for the last date in the data-set

Hi,

I would like to do a bar chart that shows sales for the latest/highest date in my dataset.  So for example if I open the application today the chart would only show me sales for 6th Jan 2011 and if i opened up the application tomorrow it would only show me the sales for 7th Jan 2011.

I then, on the same chart want to be able to show sales for that same date but for the previous year.

My sales field that i am summing on is called 'SALES_RV' and the date field is 'Excel_Date'

Thanks for your help.

Sunil

1 Solution

Accepted Solutions
vijay_iitkgp
Partner - Specialist
Partner - Specialist

Srry.....

Use

=sum( {<Excel_Date= {"$(=Max(Excel_Date))"} >} SALES_RV)

=sum( {<Excel_Date= {"$(=addmonths(Max(Excel_Date),-12))"} >} SALES_RV)

View solution in original post

3 Replies
vijay_iitkgp
Partner - Specialist
Partner - Specialist

Hi You can use this expression"

=sum( {<Date = {"$(=Max(Excel_Date))"} >} SALES_RV) for latest date and

=sum( {<Date = {"$(=addmonths(Max(Excel_Date),-12))"} >} SALES_RV) for prervious year same date

Regards

Vijay

vijay_iitkgp
Partner - Specialist
Partner - Specialist

Srry.....

Use

=sum( {<Excel_Date= {"$(=Max(Excel_Date))"} >} SALES_RV)

=sum( {<Excel_Date= {"$(=addmonths(Max(Excel_Date),-12))"} >} SALES_RV)

Sunil_Kenth
Former Employee
Former Employee
Author

Thanks Vijay