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: 
abhaysingh
Specialist II
Specialist II

Expression Help

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.

3 Replies
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
Specialist II
Specialist II
Author

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