topic Re: Set Anlysis and Number format in QlikView

Set Anlysis and Number format

leocattqv — Mon, 28 Jul 2014 22:15:04 GMT

Hi all,

I have the following formula to calculate Defective Parts per Million

sum({<[Supplier.No_Approved Parts] = {'>=1'},

[Supplier.MONTH] = {'*2014*'}>} [Supplier.QTY Rejected])

/ Sum([Supplier.No_Approved Parts]) *1000000

What I am trying to do is have a number format of ('#,###,##0')

Im not getting where to place the format.

Any suggestions? I promise to give the correct credit

thanks, in advance

-L

Re: Set Anlysis and Number format

jaimeaguilar — Mon, 28 Jul 2014 22:20:43 GMT

Hi,

if you're using this formula in a chart as an expression(pivot, straight table, bar chart, etc) then all you have to is to go to properties and in number tab you can define how you want to visualize that number. But if you're using this formula in other object like a text box then enclose your formula with num function:

num(Formula, '#,##0')

so your format will be like 1,234,000

regards

Re: Set Anlysis and Number format

leocattqv — Mon, 28 Jul 2014 22:25:44 GMT

that worked, thank you