Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Vetical and Horizontal viewing

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" ?

12 Replies
Not applicable

Re: Vetical and Horizontal viewing

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.

Not applicable

Re: Vetical and Horizontal viewing

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

..

..

...

Not applicable

Re: Vetical and Horizontal viewing

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

and then write as expression Count(Sales)

Not applicable

Re: Vetical and Horizontal viewing

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

Not applicable

Re: Vetical and Horizontal viewing

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

SenditQVblog.png

Not applicable

Re: Vetical and Horizontal viewing

attached is an example

Not applicable

Re: Vetical and Horizontal viewing

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

Not applicable

Re: Vetical and Horizontal viewing

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.

Not applicable

Re: Vetical and Horizontal viewing

1) choose your dimensions : Product and month

2)expression : Count(Product)

3)drag product to the column position

hope this help

Community Browser