topic Re: Data Configuration Issue in QlikView

Data Configuration Issue

Thu, 24 Jul 2014 12:44:39 GMT

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 !

Re: Data Configuration Issue

Or — Thu, 24 Jul 2014 14:08:34 GMT

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

Re: Data Configuration Issue

datanibbler — Thu, 24 Jul 2014 14:11:37 GMT

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