Data Configuration Issue

[#1]

Hello!

I'm on the site today to ask a quick question about data models.

Working at a pharma company, I would really like to be able to emulate this dashboard -- QlikView  Demo

And my problem is, the data I'm using to build the report is not transaction-level data. Rather, it is summarized.

In my brief experience as a user, I've found that having a column like "Order_Date," or the like, is desirable. Sadly, this data -- provided by vendors at this granularity -- has a data model something like this:

MD NAME, LOCATION, WEEK 1, WEEK 2, WEEK 3....

Bob Smith, Iowa, 0, 2, 4 (number of sales for that week)...

So, is there a way that Qlikview could process this? Would I just need to have 52 unique fields (one for each week)?

I would really appreciate any suggestions you guys have!

Thanks,

Dan !

[Or · Accepted solution]

You're in luck - it seems the Crosstable load is exactly what you need.

Henric details it better than I possible could right here:

http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/24/crosstable

[datanibbler]

Hi Daniel,

I assume that list of fieldnames that you provide is basically what your table looks like?

Well, you will have to LOAD it in several staps in order to have the week as a dimension_field. Like this:

LOAD

         MD_name,

         '[week_number]' as week,

          [WEEK 1] as sales

FROM ...;

(will be concatenated automatically)

LOAD

        MD_name,

       '[week_number]' as week,

      [WEEK 2] as sales

FROM ...;

...and so on (where [week_number] is to be the actual number of the calendar_week.

=> That way, you will end up with a table that has three fields: The MD_name, the week_nr. and the sales for that week.

HTH

Best regards,

DataNibbler