topic horizonal table in QlikView

horizonal table

surajap123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have to create a report(may be in a straight table). But the format of the report should be like below, ie. Dimensions & expressions should be one below the other and and little space and again another set in same fashion.

Product -          Pen
Product ID -       1
Brand -              abc
Sales Amount - 100

Product -           Pencil
Product ID -       2
Brand -              efj
Sales Amount - 150

Product -          Rubber
Product ID -     3
Brand -             xyz
Sales Amount - 40

Please suggest me, how to achieve this.

Re: horizonal table

Anil_Babu_Samineni — Fri, 19 May 2017 10:27:16 GMT

This will default come, When you use Pivot Table and then option for Partial Sum from Presentation for Dimensions

Re: horizonal table

tyagishaila — Fri, 19 May 2017 10:32:27 GMT

can you share sample data for both load file and output report.(in a table format)?

Re: horizonal table

surajap123 — Fri, 19 May 2017 10:38:42 GMT

Thanks for the reply.

I want dimensions one below the other. The options you have specified doesn't format the table as I shown above.

Re: horizonal table

surajap123 — Fri, 19 May 2017 10:41:20 GMT

Hi Shaila,

Here is the data.

LOAD * INLINE [
Product, ProductID, Brand, Sales Amount
Pen, 1, abc, 100
Pencil, 2, efj, 150
Rubber, 3, xyz, 50
];

Re: horizonal table

tyagishaila — Fri, 19 May 2017 10:59:35 GMT

and output?

Re: horizonal table

surajap123 — Fri, 19 May 2017 11:11:06 GMT

The output I mentioned in my initial post.

Re: horizonal table

Frank_Hartmann — Fri, 19 May 2017 11:20:41 GMT

try this in a textbox:

= 'Product - '& subfield(Concat(DISTINCT(Product),'|',1),'|',1)&Chr(10)&

'Product ID - '&subfield(Concat(DISTINCT(ProductID),'|',1),'|',1)&Chr(10)&

'Brand -'& subfield(Concat(DISTINCT(Brand),'|',1),'|',1)&Chr(10)&

'Sales Amount -'&subfield(Concat(DISTINCT([Sales Amount]),'|',1),'|',1)&Chr(10)&

Chr(10)&

'Product - '& subfield(Concat(DISTINCT(Product),'|',1),'|',2)&Chr(10)&

'Product ID - '&subfield(Concat(DISTINCT(ProductID),'|',1),'|',2)&Chr(10)&

'Brand -'& subfield(Concat(DISTINCT(Brand),'|',1),'|',2)&Chr(10)&

'Sales Amount -'&subfield(Concat(DISTINCT([Sales Amount]),'|',1),'|',2)&Chr(10)&

Chr(10)&

'Product - '& subfield(Concat(DISTINCT(Product),'|',1),'|',3)&Chr(10)&

'Product ID - '&subfield(Concat(DISTINCT(ProductID),'|',1),'|',3)&Chr(10)&

'Brand -'& subfield(Concat(DISTINCT(Brand),'|',1),'|',3)&Chr(10)&

'Sales Amount -'&subfield(Concat(DISTINCT([Sales Amount]),'|',1),'|',3)&Chr(10)&

hope this helps

Re: horizonal table

Anil_Babu_Samineni — Fri, 19 May 2017 11:21:53 GMT

I doubt, Whether we have that option. It takes much time right while we have more than 10/15 slides.

How about this?

Re: horizonal table

Anil_Babu_Samineni — Fri, 19 May 2017 11:22:22 GMT

Or else, always we need to create each table together and then club, This must be a Work Around

Re: horizonal table

tyagishaila — Fri, 19 May 2017 11:43:55 GMT

Check it, and let me know is it possible in your data?

Re: horizonal table

tyagishaila — Fri, 19 May 2017 11:49:45 GMT

and for blank row

you can concatenate 1 more table like below

Concatenate(TAB1)

Load

' ' as f1,

' ' as f2,

RecNo() as f3

Resident TAB;

Re: horizonal table

surajap123 — Fri, 19 May 2017 12:16:12 GMT

Sorry I didn't get it.

Re: horizonal table

surajap123 — Fri, 19 May 2017 12:17:23 GMT

Hi Frank,

Thanks for all your effort. The text object doesn't react to user selections, But I found your solution interesting.

Re: horizonal table

tyagishaila — Fri, 19 May 2017 12:18:52 GMT

have you seen sample.qvw?

Re: horizonal table

tyagishaila — Fri, 19 May 2017 12:21:52 GMT

is this your requirement or not?

f3	f1	f2
1	Product	Pen
1	ProductID	1
1	Brand	abc
1	SalesAmount	100
1
2	Product	Pencil
2	ProductID	2
2	Brand	efj
2	SalesAmount	150
2
3	Product	Rubber
3	ProductID	3
3	Brand	xyz
3	SalesAmount	50
3

Re: horizonal table

surajap123 — Fri, 19 May 2017 12:22:05 GMT

Yes.

Can you do it with my data. Probably you can add more rows if you want.

I am more interested in the layout, so you can try using any data as long as the layout appear as my initial post.

Re: horizonal table

surajap123 — Fri, 19 May 2017 12:23:23 GMT

Yes, without the top headers.

Re: horizonal table

tyagishaila — Fri, 19 May 2017 12:28:45 GMT

you can remove Headers by clicking on

Suppress Header Row in Presentation Tab.

Re: horizonal table

Frank_Hartmann — Fri, 19 May 2017 13:32:43 GMT

another solution might be in attached sample but i really don't know how to involve the blank rows

after each block!