topic Re: Set Analysis Errore in QlikView

Set Analysis Errore

Fri, 20 Nov 2020 18:02:30 GMT

Hi,

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

settu_periasamy — Mon, 14 Dec 2015 03:02:22 GMT

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 — Mon, 14 Dec 2015 03:02:44 GMT

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.

Mon, 14 Dec 2015 03:08:11 GMT

thanku juan,

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

settu_periasamy — Mon, 14 Dec 2015 03:31:17 GMT

Hi,

Check the Attachment.