Qlik Community

Ask a Question

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

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

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

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

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

Not applicable

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

SenditQVblog.png

Not applicable

attached is an example

Not applicable

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

Not applicable

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

1) choose your dimensions : Product and month

2)expression : Count(Product)

3)drag product to the column position

hope this help