topic Re: Vetical and Horizontal viewing in QlikView

Vetical and Horizontal viewing

Sat, 19 Jan 2013 17:19:14 GMT

Let One dimesion's members be listed vertically across the members of the other one dimesion's members which take place horizontally. How can we create like that tabular report?

Is this "slicing" ?

Re: Vetical and Horizontal viewing

Sat, 19 Jan 2013 17:53:49 GMT

Hi,

You can try using Pivot table Chart for this. Go to Chart Properties - General Tab and select Pivot Table as the chart type. You can click and drag dimensions to arrange horizontally or vertically.

Here's a sample app for the same.

Hope it helps.

Regards,

-Khaled.

Re: Vetical and Horizontal viewing

Sat, 19 Jan 2013 20:21:27 GMT

Thanks Khaled but I know using pivot table: it has one dimension as vertical and the other dimensions as horizontally. But this is not what I am looking for. I am looking for a way that I can describe one dimesion as vertically (sales like below) but I also can describe the members of only one dimesion (months like below) as horizontally. Like that:

sales Jan Feb Mar Apr May .... .... ....

Pencils xx xx xx xx xx

Books xx xx xx xx xx

...

Re: Vetical and Horizontal viewing

Sat, 19 Jan 2013 20:25:04 GMT

if pencils and books are sales, in pivot table choose both sales and monthname as dimension

and then write as expression Count(Sales)

Re: Vetical and Horizontal viewing

Sat, 19 Jan 2013 20:26:02 GMT

if you have the imported table of data please put it to show u a qvw file for it

Re: Vetical and Horizontal viewing

Sat, 19 Jan 2013 21:03:18 GMT

Here it is. But I want that Months take place horizontrally not vertically like below.

Re: Vetical and Horizontal viewing

Sat, 19 Jan 2013 21:13:09 GMT

attached is an example

Re: Vetical and Horizontal viewing

Sat, 19 Jan 2013 21:21:37 GMT

Bilalebald, can you give it as a screenshot (I cannot open your qlikview apps because of my personal licence.

Re: Vetical and Horizontal viewing

Sat, 19 Jan 2013 21:23:24 GMT

Hi,

You can transpose, promote dimensions but cannot change the alignment of rows to columns as such. Please check the attachment to see if it helps.

Regards,

-Khaled.

Re: Vetical and Horizontal viewing

Sat, 19 Jan 2013 21:27:41 GMT

1) choose your dimensions : Product and month

2)expression : Count(Product)

3)drag product to the column position

hope this help

Re: Vetical and Horizontal viewing

Sun, 20 Jan 2013 19:09:52 GMT

Unfortunately I couldn't do it, Bilalelabd.

Re: Vetical and Horizontal viewing

Sun, 20 Jan 2013 19:10:58 GMT

Can you send your files as a screenshot pls Khaled ?

Re: Vetical and Horizontal viewing

Mon, 21 Jan 2013 19:17:57 GMT

Hi,

Here are the screenshots of the tables from the attachments. Just to mention, you can achieve something like these by pivoting the columns of your pivot table.

Hope it helps.

Regards,

-Khaled.