topic Re: Decimal Places TextBox in QlikView

Decimal Places TextBox

Mon, 29 Feb 2016 14:36:45 GMT

Hi All,

I'm trying to have two decimal places for the below expression in the text box, it's not working. I've tried the round and the floor function also but no fruition. The comma at the end seems to have an error pertinent to it.

Thanks in advance,

=(num(Sum({[BookRev]<QuarterNum={"$(=Max({$}QuarterNum))"}, [DimYear] ={"$(=Max({$}[DimYear]))"}>} grossamount)

Sum({[BookRev]<QuarterNum={"$(=If(Max({$}QuarterNum) - 1 = 0, 4, Max({$}QuarterNum)-1))"}, [DimYear] ={"$(=If(Max({$}QuarterNum) - 1 = 0, Max({$}[DimYear]) - 1, Max({$}[DimYear])))"}>} grossamount)) * 4

Sum({[BookCost]<QuarterNum={"$(=If(Max({$}QuarterNum) - 1 = 0, 4, Max({$}QuarterNum)-1))"}, [DimYear] ={"$(=If(Max({$}QuarterNum) - 1 = 0, Max({$}[DimYear]) - 1, Max({$}[DimYear])))"}>} grossamount), '# ##0', '', ' ')

Re: Decimal Places TextBox

sunny_talwar — Mon, 29 Feb 2016 14:39:02 GMT

Try this:

=Num((Sum({[BookRev]<QuarterNum={"$(=Max({$}QuarterNum))"}, [DimYear] ={"$(=Max({$}[DimYear]))"}>} grossamount)

Re: Decimal Places TextBox

Mon, 29 Feb 2016 14:41:38 GMT

Still shows an error.

Re: Decimal Places TextBox

sunny_talwar — Mon, 29 Feb 2016 14:43:18 GMT

Can you share a screenshot for the complete expression?

Re: Decimal Places TextBox

t_chetirbok — Mon, 29 Feb 2016 14:56:26 GMT

hello!

It's should work:

num(

Sum({[BookRev]<QuarterNum={"$(=Max({$}QuarterNum))"}, [DimYear] ={"$(=Max({$}[DimYear]))"}>} grossamount)

Sum({[BookCost]<QuarterNum={"$(=If(Max({$}QuarterNum) - 1 = 0, 4, Max({$}QuarterNum)-1))"}, [DimYear] ={"$(=If(Max({$}QuarterNum) - 1 = 0, Max({$}[DimYear]) - 1, Max({$}[DimYear])))"}>} grossamount)

,'# ##0.00')

Re: Decimal Places TextBox

pooja_sn — Mon, 29 Feb 2016 14:59:19 GMT

=(num(
(
Sum({[BookRev]<QuarterNum={"$(=Max({$}QuarterNum))"}, [DimYear] ={"$(=Max({$}[DimYear]))"}>} grossamount)

Re: Decimal Places TextBox

Anonymous — Mon, 29 Feb 2016 15:11:03 GMT

Hi!

Try.

=num(

Sum({[BookRev]<QuarterNum={"$(=Max({$}QuarterNum))"}, [DimYear] ={"$(=Max({$}[DimYear]))"}>} grossamount)

Regards.

Re: Decimal Places TextBox

Mon, 29 Feb 2016 16:06:47 GMT

Thanks for all your help guys.

Re: Decimal Places TextBox

Anonymous — Mon, 29 Feb 2016 16:51:15 GMT

You're welcome!