Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
We value your feedback – take our 5-minute QlikView modernization survey
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis Errore

Hi,

i want to show the sales of current month and last month.am getting a syntax errore plz help me .

1 Solution

Accepted Solutions
settu_periasamy
Master III
Master III

Hi,

Check the Attachment.

View solution in original post

4 Replies
settu_periasamy
Master III
Master III

Hi,

I think your date format is not proper, try to change it like

[Month Year]  :  Date(Date#([Month Year],'MMM YYYY'),'MMM YYYY') as Month Year

Check the attachment, may be helps..

jolivares
Specialist
Specialist

First take care with the field [Month Year], it don't have a date format so is convenient that you give it the right format in the script.

Capture.PNG

Not applicable
Author

thanku juan,

iit's working fine but by defaul it should show max sales and max-1 sales

settu_periasamy
Master III
Master III

Hi,

Check the Attachment.