Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

siva0606
New Contributor II

Week

I have attached two excel files. Excel1 file is the table which i has. But, i want a table in the format which is in Excel2 nd file.

1 Solution

Accepted Solutions
sujeetsingh
Honored Contributor III

Re: Week

Siv ,

Just use 'Week'&'-'&week(Datefield) as dimension it will be done

5 Replies
hschultz
Contributor

Re: Week

Why is it that Jan week 4 is 20? How would you know how to distribute if it isn't Revenue/Weeks per entry?

sujeetsingh
Honored Contributor III

Re: Week

Siv ,

Just use 'Week'&'-'&week(Datefield) as dimension it will be done

siva0606
New Contributor II

Re: Week

Hi schultz,

Its jus an assumed value

siva0606
New Contributor II

Re: Week

Thank you

sujeetsingh
Honored Contributor III

Re: Week

if you are completely satisfied then end this thread as Answered or Helpful answer

Thanks

Community Browser