Expression Help

[abhaysingh]

HI All,

i have Week Field in which some numeric values are there i want to Do Current Month with last three month trail.

what would be exression???

Field Names -

Date, Week, day, month

and one more thing Week are in Number 1,2,3,4,.....53. first i want week in this form W, W1, W2, .....W53.

when i am tring Max(Week), it is giving me 53. but when i m converting week into W1, W2 form max(week) giving me nothing.

Pls Help.

[marcus_sommer]

I don't understand your first issue but by the second you could use dual like:

dual('W' & week(date), week(date)) as Week

to have the week as string and as numeric.

- Marcus

[abhaysingh]

Hi marcus,

thanks for revert, i have to show current week sales with last three week sales in a trend.

[marcus_sommer]

I think you will find here many examples to similar cases:

https://community.qlik.com/search.jspa?q=compare+week+previous+week

- Marcus