topic Re: Formatting a Calculated Dimension in QlikView

Formatting a Calculated Dimension

Thu, 17 Oct 2013 13:46:34 GMT

Hi,

Does anyone know how i can format a calculated dimension? I am trying to limit the number of decimal places displayed on my graph for the calculated dimension but the number format tab in my chart properties seem sto only apply to the expression in the chart.

Thanks!

Re: Formatting a Calculated Dimension

Thu, 17 Oct 2013 13:52:02 GMT

You can use Num(your calculated dimension,'###,###.##') with however many decimal places you want.

Re: Formatting a Calculated Dimension

MayilVahanan — Thu, 17 Oct 2013 13:52:05 GMT

You can able to apply num() function in calculated dimension.

Ex:

Num(Sales,'####.#0')

Re: Formatting a Calculated Dimension

Sat, 11 Apr 2015 07:09:10 GMT

You can apply as below:

=aggr(sum(num(Your value,'#,###.##')),Your value)

Thanks

Re: Formatting a Calculated Dimension

cleite2014 — Wed, 22 Apr 2015 16:45:23 GMT

I have two functions as below that will not format to numbers when exported to excel. Is there another method to get all numeric values to import as a number in excel? I am using Excel 2010.

Any ideas?

=round(aggr(sum(num(Hours,'###,###')), Owner)

=round(aggr(sum(num(Hours,'###,###')), Project, Owner)

Thank you,