topic Re: Expression Help in QlikView

Expression Help

abhaysingh — Sun, 26 Apr 2015 16:47:39 GMT

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 — Sun, 26 Apr 2015 17:18:24 GMT

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 — Sun, 26 Apr 2015 17:29:36 GMT

Hi marcus,

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

marcus_sommer — Sun, 26 Apr 2015 18:42:54 GMT

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

- Marcus