Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

concenate weeks which are fields with the year in rows

Hi,

There is a thing and it' s disappointing that i couldn't find a solution yet. which is:

- there are weeks in fields like week1, week2, week3 to week 57

- there is a year field containing 2010 to 2013.

i decreased these 52 fields of weeks to two fields using cross table, and now i have a week field and it contains weeks like:

Week

Week1

Week2

-

-

-

-

When i use pivot table i use week and data fields as a dimension and with a year listbox i can list the values for an nth week of x year.

I' ve merged this week and year fields (weekyear).  But after this operation, i cant see the week and year' s (weekyear) value as i can see the week values in table.

The table exists empty.

I wonder if someone can help me with this situation. any help would be very appreciated.

Thanks a lot, regards,

Ozzyefendi.

1 Reply
jagan
Partner - Champion III
Partner - Champion III

Hi,

Can you attach the sample file you are working?


Regards,

Jagan.