Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Hi marcus,
thanks for revert, i have to show current week sales with last three week sales in a trend.
I think you will find here many examples to similar cases:
https://community.qlik.com/search.jspa?q=compare+week+previous+week
- Marcus