how to add 4 WEEK to today date()

[israrkhan]

hi all,

i am learning qlikview, have a very basic question...

i want to add 4 weeks to current date,(i am using today() function for getting current date)

i am trying some thing like... =week(today()+4)...

but its showing me (-)....

it must show, because i am wrong....

any body would like to help me please...

Kind Regards.

Israr

[manideep78 · Accepted solution]

Try this

Week(Today())+4

[#3]

try this

=date(Today() + 28)

[israrkhan]

dear Mandeep...

you are just great...

thank you so much....

i was writing inside the braces....

thank you again...

One more question please...

1) how to get the associated columns of a  current selection in set analysis.

for example, i select country in list a, and in list b one city in associated,(colour is gray)

how can i get that city name...?

please...

[#5]

in script--

LOAD * INLINE [

    a, b

    2001, india

    2002, aus

    2003, britain

    2004, america

];

then on text object write

=only({$} b)

[manideep78]

Only(b)