topic Re: Help on Stacked reports in QlikView

Help on Stacked reports

Mon, 26 Jan 2026 18:19:17 GMT

Hi, I am creating a report and layout request products in the bottom listed all items, then Category on the top of products . Is there any way like SSRS of outside group so I can use the data set again instead of loading the data one or two more times.

	Qty	Sales
Total	100	12000
Category1	60	11500
Non-Category1	40	500
Category1	60	11500
Product1	30	10000
Product2	20	1000
Product3	10	500
Category2	30	300
Product1	20	100
Product2	10	200
Category3	10	200
Product1	8	100
Product3	2	100

Thank you so much.

Re: Help on Stacked reports

Gysbert_Wassenaar — Tue, 22 Mar 2016 15:41:46 GMT

I don't understand what you're asking. What's the source data and what is the result you want to see?

Re: Help on Stacked reports

Tue, 22 Mar 2016 22:41:57 GMT

I do not have the source file. But the report come out should be like the above lay out.

Category1 repeat once and category2 and category3 combined as Non-Category1, then total in same level.

	Qty	Sales
Total	100	12000
Category1	60	11500
Non-Category1	40	500
Category1	60	11500
Product1	30	10000
Product2	20	1000
Product3	10	500
Category2	30	300
Product1	20	100
Product2	10	200
Category3	10	200
Product1	8	100
Product3	2	100

Re: Help on Stacked reports

Gysbert_Wassenaar — Wed, 23 Mar 2016 06:38:13 GMT

If you don't have source data then you can't create the end result unless you're just creating your own fake data.

Re: Help on Stacked reports

Wed, 23 Mar 2016 13:14:43 GMT

Hi, Gysbert,

I made a fake data.

data:

OrderID	Category	Product	Qty	Sales
1	Category1	Product1	5	500
2	Category1	Product1	4	100
3	Category1	Product2	2	300
4	Category1	Product3	6	400
5	Category1	Product3	8	200
6	Category1	Product3	8	100
7	Category2	Product1	5	500
8	Category2	Product1	4	100
9	Category2	Product2	2	300
10	Category2	Product3	6	400
11	Category2	Product3	5	100
12	Category3	Product2	3	90
13	Category3	Product3	8	100
14	Category3	Product3	6	50
15	Category3	Product3	8	100

Report looks like:

Total	80	3340
Category1	33	1600
Non-Category1	47	1740
Category1	33	1600
Product1	9	600
Product2	2	300
Product3	22	700
Category2	22	1400
Product1	9	600
Product2	2	300
Product3	11	500
Category3	25	340
Product2	3	90
Product3	22	250

Re: Help on Stacked reports

Wed, 06 Apr 2016 01:17:41 GMT

Hi, guys, can anyone help me with my question please? It is an issue at work. I do not have a clue. I appreciate your help.

Re: Help on Stacked reports

Gysbert_Wassenaar — Wed, 06 Apr 2016 14:42:34 GMT

See attached example

Re: Help on Stacked reports

Saravanan_Desingh — Thu, 07 Apr 2016 02:37:16 GMT

Hi gwassenaar‌,

Can you please explain, how you format the two Pivot tables? I could not recreate it.

This is really nice. Thank you.

Re: Help on Stacked reports

Gysbert_Wassenaar — Thu, 07 Apr 2016 05:33:11 GMT

You can enable the Indent option on the Style tab and you can use the Custom Format Cell option to change the background color of the headers. If you choose Design Grid in the View menu then you can right-click a header cell, choose Custom Format Cell from the context menu and change the formatting of the cell.

Re: Help on Stacked reports

Chanty4u — Thu, 07 Apr 2016 05:47:26 GMT

chk dis

Select View -> View-Grid View -> right click your straight table select -> Custom Format Cell

and format as per your requirement

Custom Format Cells in Straight Table

Re: Help on Stacked reports

Saravanan_Desingh — Thu, 07 Apr 2016 15:06:39 GMT

Hi gwassenaar‌, chanty4u‌

Thank you so much. I have not used the Style-Indent Mode & Custom Format Cell before.

This is amazing. I have learnt few things today

Re: Help on Stacked reports

Fri, 08 Apr 2016 15:18:35 GMT

Hi, Gysbert,

Thank you very much for your reply. But sadly I cannot open your application because of personal addition or maybe some other reason I do not know.

Can you give me a pdf or word format temporary for now and I will fix my licence problem later because I need your help to finish my work?

Thank you so much.

Re: Help on Stacked reports

Gysbert_Wassenaar — Fri, 08 Apr 2016 16:50:27 GMT

I'm afraid a pdf of word document is of no use to you. Perhaps you can lease a license from a Qlikview Server in your organisation. Or install Qlikview Personal in a virtual machine and use a recovery to open my example to see how it's put together.

Re: Help on Stacked reports

Fri, 08 Apr 2016 18:11:56 GMT

Gysbert, got it. Thank you very much.

Re: Help on Stacked reports

Sat, 09 Apr 2016 01:38:05 GMT

Hi, Gysbert,

So what you created are two chart, and you take off the caption. Put them close to each other.

Can I know if I am correct?

Re: Help on Stacked reports

Sat, 09 Apr 2016 01:40:49 GMT

Hi, Saran7de,

Do you think this is how the Qlikview works? I think if it is I may prefer to use glue.

Re: Help on Stacked reports

Gysbert_Wassenaar — Sun, 10 Apr 2016 15:03:16 GMT

Yes, that's correct.

Re: Help on Stacked reports

Sun, 10 Apr 2016 22:50:59 GMT

Hi, Gysbert,

Are you working for Qlikview? The reason I asked is if you are working for Qlikview, you will be familiar with Qlik very much. So you will know that Qlikview may not have the ability to create this type of reports.

If you are not working for Qlikview, there might have a solution to create the report in one chart instead of glue them together.

Thank you.

Re: Help on Stacked reports

Gysbert_Wassenaar — Mon, 11 Apr 2016 05:57:36 GMT

I'm not working for Qlik. Qlik employees can be identified by a green star icon after their profile name.

It is probably possible to create a single chart that looks like that. But you will have to change your data model to shape the data such that it becomes possible. One option is to use techniques similar to the ones described in this blog post: How IntervalMatch Solved My Profit and Loss Dilemma

Re: Help on Stacked reports

Wed, 13 Apr 2016 14:41:14 GMT

Gysbert, Thank you.