topic Blank Line Under Subtotals in QlikView

Blank Line Under Subtotals

Fri, 16 Oct 2009 19:48:50 GMT

Hi Folks,

Has anybody any idea how I can get a blank line under each subtotal in a pivot table. I have tried entering a blank dimension but I cannot seem to get what I require.

Kind Regards,

Footsie

Blank Line Under Subtotals

Fri, 16 Oct 2009 20:15:48 GMT

If (dimensionnality()=xx,' ',sum(field))

Where xx is the level where your subtotal is.

Rgds,

Blank Line Under Subtotals

Fri, 16 Oct 2009 20:22:50 GMT

hi spastor, I do not think that your example is solving this problem. It will not add blank row to a pivot table after a subtotal row. Actually I do not think that this is possible but if somebody has a solution, I am looking forward to see it.

cheers

karol

Blank Line Under Subtotals

Fri, 16 Oct 2009 20:27:16 GMT

Hi spastor,karol,

Thank you for your responses. I cannot get your suggestion to work spastor and am having some trouble coming up with a solution to my issue. I will keep trying 🙂

Thanks again,

Footsie

Blank Line Under Subtotals

Fri, 16 Oct 2009 20:29:10 GMT

Hello Footsie,

are you looking for something like this

Talha

Blank Line Under Subtotals

Fri, 16 Oct 2009 20:34:00 GMT

What you can do is changing the colour of your expressioin depending on dimensionnality().

IF(dimensionality()=2,rgb(255,255,255)) for example ?

Rgds,

Sébastien

Blank Line Under Subtotals

Fri, 16 Oct 2009 20:35:45 GMT

Hi Talha,

Thanks for the response

Yes it is something along those lines that I am looking for but I already have 3 expressions in the chart and I need the blank line under the subtotals for the three expressions. I cannot get your sample to work with more than 1 expression in the chart.

Kind Regards

Footsie

Blank Line Under Subtotals

Fri, 16 Oct 2009 20:39:50 GMT

actually I found a solution, but it is nasty and requires some dummy data creation during the load. See attached example:)

Blank Line Under Subtotals

Fri, 16 Oct 2009 20:40:21 GMT

forgot to attach file:)

Blank Line Under Subtotals

Fri, 16 Oct 2009 20:49:48 GMT

Footsie Maybe i am not getting it fully but when i tried with 3 expressions it is showing up 3 blank line attached please see

Talha

Blank Line Under Subtotals

Fri, 16 Oct 2009 20:56:18 GMT

Karol,

That is a very interesting solution and it gives me what I need with small sample of data. The actual application in question is quite large so ultimately I do not think it is a feasible solution. I like your way of thinking though.

Talha,

Thanks also for your suggestion. I need the three existing expressions to be displayed horizontally however so your suggestion will not work for me.

Kind Regards

Footsie

Blank Line Under Subtotals

Fri, 16 Oct 2009 20:58:15 GMT

I guess if you want to use footsie solution create only one '' expression as the last expression.

Blank Line Under Subtotals

Fri, 16 Oct 2009 21:05:04 GMT

Hi Folks,

The attached example is what I am trying to achive but with a large dataset.

Kind Regards

Footsie

Blank Line Under Subtotals

Fri, 16 Oct 2009 21:07:14 GMT

Or you could just go to Dimensions and select the Dimension it is doing the sub-totals on > then click Advanced, check 'Spacing' and enter 15(or any size you want).

It will auto-matically place a neat line under each sub-total row.

Thanks