topic Row data as column data showing a trend per fact in QlikView

Row data as column data showing a trend per fact

Mon, 30 May 2011 13:52:07 GMT

Hello,

I was wondering if it is possible to create statistics where row-data becomes column data...

I enclosed an example which demonstrates the current sitation.

The 2B situation can be found in the attached screenshot.

As a general goal, I would like to see the evolution a fact (i.e. person X) goes through within a period of time...

The fact data is now stored as seperate rows, which now I would like to visualize as columns in a chart object.

Any help is highly appriciated.

Kind regards,

Maarten

nagaiank — Mon, 30 May 2011 14:29:28 GMT

You may try a pivot table chart. An example is attached.

Mon, 30 May 2011 14:39:14 GMT

Hi,

this is exactly what I was trying to do myself too....

I'll have to figure out what you exactly did, because when I try to reproduce the pivot table myself, it remains empty 🙂

How did you define the blue and the red color? (I suppose it indicates the trend (up/down))

Thanks a lot!

Very fast, and straight to the point!

Regards,

Maarten

nagaiank — Mon, 30 May 2011 14:49:10 GMT

I also got an empty pivot table.

In order expand the pivot table, I selected a person and time

Then moved the time dimension to columns by dragging it above the result.

To set color, click on the sign near the Result in expressions tab, and set the Text color in the 'Definition' box on the right.

Hope this helps.

Mon, 30 May 2011 14:54:46 GMT

Wow, that's a whole new world opening in front of me 🙂

In excel I knew how it works, but Qlikview ...

Anyway, excellent job in explaining this functionality! Thanks!