Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Help on Stacked reports

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.

  

QtySales
Total10012000
  Category16011500
  Non-Category140500
    Category16011500
        Product13010000
        Product2201000
        Product310500
    Category230300
        Product120100
        Product210200
    Category310200
        Product18100
        Product32

100

Thank you so much.

19 Replies

Re: Help on Stacked reports

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


talk is cheap, supply exceeds demand
Not applicable

Re: Help on Stacked reports

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.

QtySales
Total10012000
  Category16011500
  Non-Category140500
    Category16011500
        Product13010000
        Product2201000
        Product310500
    Category230300
        Product120100
        Product210200
    Category310200
        Product18100
        Product32

100

Re: Help on Stacked reports

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


talk is cheap, supply exceeds demand
Not applicable

Re: Help on Stacked reports

Hi, Gysbert,

I made a fake data.

data:

OrderIDCategoryProductQtySales
1Category1Product15500
2Category1Product14100
3Category1Product22300
4Category1Product36400
5Category1Product38200
6Category1Product38100
7Category2Product15500
8Category2Product14100
9Category2Product22300
10Category2Product36400
11Category2Product35100
12Category3Product2390
13Category3Product38100
14Category3Product3650
15Category3Product38100

Report looks like:

   

Total803340
Category1331600
Non-Category1471740
Category1331600
Product19600
Product22300
Product322700
Category2221400
Product19600
Product22300
Product311500
Category325340
Product2390
Product322250
Not applicable

Re: Help on Stacked reports

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

See attached example


talk is cheap, supply exceeds demand
saran7de
Contributor III

Re: Help on Stacked reports

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

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.


talk is cheap, supply exceeds demand
sureshqv
Esteemed Contributor III

Re: Help on Stacked reports

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