topic Dates as Column names in QlikView

Dates as Column names

Tue, 10 Aug 2010 11:47:46 GMT

Hi,

I need help on how I could use dates as column names. As an example, if you wanted to view sales per person, per day in a selected month. In the example below, I'm just using a month with days 1 through to 9, with sales people John and Sue.

Sales People Days

1 2 3 4 5 6 7 8 9 ...

John 2 4 0 6 4 3 5 4 1

Sue 0 3 4 3 3 1 0 5 2

I'm unable to get the days as columns. What I'm getting at the moment is a sum of sales per Salesperson per period selected, as below

Sales People Period (1 - 9 March Selected)

John 29

Sue 21

I'll appreciate any help on this.

Thanks,

Shane

Dates as Column names

Tue, 10 Aug 2010 11:59:00 GMT

Hi,

Have you used the Date field in the column? It looks like you have used period in the column instead of date.

-Haneesh

Dates as Column names

Tue, 10 Aug 2010 12:11:29 GMT

Hi,

If you have dates in row- a dimension in your chart, just keep your mouse on that column and drag it across.

You will find a blue color arrow pointing towards column titles.

Take your dragged column to expression area where you will see that Blue arrow has become horizontle pointing left.

Drop cursor / mouse there itself.

Your dates will be horizontaly placed.

Happy Thoughts

Dates as Column names

Tue, 10 Aug 2010 12:49:12 GMT

Thanks HT,

I see the blue arrow when I drag the column but the arrow remains vertical. I'm not sure if you mean that I must drag the arrow to the expression area where it will change to horizontal. When I right click the object and click properties > Expression Tab, the window is modal which means that I cannot drag the blue arrow into the Expression area.

I'm not sure if the version will make a difference but I'm using version 9.00.7320.0409

Is there a way of docking the Properties Window so that I can drag the arrow into the expression area?

Thanks for your help

Dates as Column names

Tue, 10 Aug 2010 13:15:53 GMT

Hi,

I hope your table/Chart is a "Pivot Chart" and not anything else and also it has got Expression field.

If these two conditions are satisfied then you must get it right.

Convert your chart to Pivot chart form and then try it.

If you still don't get it, plz share QV file with a some sample data and expected table format.

I will provide you solution.

Happy Thoughts

Dates as Column names

Tue, 10 Aug 2010 13:37:33 GMT

Ravi,

You are the man! Thank you so much, such a quick fix and since I'm a bit of a QV beginner, I really appreciate that.

Have an awesome day!

Shane