topic Weekday function in QlikView

Weekday function

Sun, 13 Feb 2011 09:14:55 GMT

Hi,

I tried to use the weekday function in the Group expression. It is showing the random day names and also only day is displayed in the graph. Is it possible to use the Weekday function in the Group functions....

Weekday function

prieper — Sun, 13 Feb 2011 22:12:19 GMT

The WEEKDAY-function should return only a value from 0 to 6 which then is interpreted as Daynames (loaded in the beginning of the script). Make sure that the date you wish to convert is in the same format as in your operating system, otherwise you may force the interpretatioin with

WEEKDAY(DATE#(20110213, 'YYYYMMDD'))

HTH
Peter

Weekday function

Mon, 14 Feb 2011 10:32:42 GMT

Thanks Peter,

but i want to use the column instead of a static value. if we use the column then it is showing only one day.

Weekday function

prieper — Mon, 14 Feb 2011 10:53:54 GMT

I do not get the point, can you please post an example?

Peter

Weekday function

Tue, 15 Feb 2011 07:07:01 GMT

Hi Peter,

I am trying in the below way in the Cyclic group expression Weekday(Date). So when i am choosing the weekday it is showing only tuesday not any other days.

Weekday function

prieper — Tue, 15 Feb 2011 20:17:33 GMT

See the attached

HTH
Peter