Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

set analysis syntax errore

Hi,

am getting  syntax   errore  to find max month year sales and max month year -1 sales

1 Solution

Accepted Solutions
sunny_talwar

Try this expression for max may be:

Max Month

=Sum({$<[Month Year]= {"$(=max([Month Year]))"}>}Sales)

Max Month - 1

=Sum({$<[Month Year]= {"$(=Max(AddMonths([Month Year], -1)))"}>}Sales)

View solution in original post

1 Reply
sunny_talwar

Try this expression for max may be:

Max Month

=Sum({$<[Month Year]= {"$(=max([Month Year]))"}>}Sales)

Max Month - 1

=Sum({$<[Month Year]= {"$(=Max(AddMonths([Month Year], -1)))"}>}Sales)

View solution in original post