topic Re: Dimensionality in QlikView

Dimensionality

Tue, 17 Dec 2013 19:36:14 GMT

I want to insert subtotal for expressions. Since partial sums label does not allow custom label , I used dimensionality function for the expression. But I am having an issue where the text for the subtotal is showing as left aligned. I want this to be right aligned. I searched the function list but could not find it. Is there a way to set the alignment within expression ?

(Dimensionality()=1,'Subtotal ' & Group & ' ' & round(Sum( {<Source = {'CurrentSales'}>} Amount),1),Sum( {<Source = {'CurrentSales'}>} Amount))

Re: Dimensionality

Gysbert_Wassenaar — Tue, 17 Dec 2013 20:08:46 GMT

You can set the alignment on the Presentation tab. You can set it for text values and number values separately. You seem to want to have both settings to Right.

Re: Dimensionality

Tue, 17 Dec 2013 20:12:08 GMT

Didn't realize expressions are also listed there. Thanks!

Re: Re: Dimensionality

jolivares — Fri, 20 Dec 2013 13:52:35 GMT

Hi Gysbert, may you see the example attached? I was trying to acumulate values in the subtotal but I failed.

See please.

Re: Re: Re: Dimensionality

Gysbert_Wassenaar — Fri, 20 Dec 2013 15:38:12 GMT

See attached qvw.