topic Re: Set analysis - text object in QlikView

Set analysis - text object

Wed, 25 Nov 2020 16:16:04 GMT

Hello guys,

At this moment i want to have a correct € format in the red markered text object value, but i dont get the format €18.685,58.

The current expression of this text object is:

=Num(Round(sum({$<StoreCode = {'WSDP', 'WSBK', 'WSBM', 'WSMB', 'WSB1', 'WSB2'}>} SalesPrice*TransactionQuantity))
- Sum({$<StoreCode = {'WSDP', 'WSBK', 'WSBM', 'WSMB', 'WSB1', 'WSB2'}>}GrossValue-DiscountValue))
-
Num(round(sum({$<Year={$(=Only(Year))}, Month={$(vPriorMonth)}, StoreCode={'WSDP', 'WSBK', 'WSBM', 'WSMB', 'WSB1', 'WSB2'}>}TransactionQuantity*SalesPrice))
- sum({$<Year={$(=Only(Year))}, Month={$(vPriorMonth)}, StoreCode={'WSDP', 'WSBK', 'WSBM', 'WSMB', 'WSB1', 'WSB2'}>}GrossValue-DiscountValue),'€ #.##0,')

which expression do i have to change to get €18.685,58 ?

thanks.

Re: Set analysis - text object

swuehl — Fri, 06 May 2016 09:37:57 GMT

Try

=Num(

Round(sum({$<StoreCode = {'WSDP', 'WSBK', 'WSBM', 'WSMB', 'WSB1', 'WSB2'}>} SalesPrice*TransactionQuantity))
- Sum({$<StoreCode = {'WSDP', 'WSBK', 'WSBM', 'WSMB', 'WSB1', 'WSB2'}>}GrossValue-DiscountValue)
-
Round(sum({$<Year={$(=Only(Year))}, Month={$(vPriorMonth)}, StoreCode={'WSDP', 'WSBK', 'WSBM', 'WSMB', 'WSB1', 'WSB2'}>}TransactionQuantity*SalesPrice))
- sum({$<Year={$(=Only(Year))}, Month={$(vPriorMonth)}, StoreCode={'WSDP', 'WSBK', 'WSBM', 'WSMB', 'WSB1', 'WSB2'}>}GrossValue-DiscountValue)

,'€ #.##0,',',','.')

i.e. one num() function that formats the complete calculations (recheck the brackets)

Re: Set analysis - text object

Anonymous — Fri, 06 May 2016 09:40:30 GMT

=Num(Round(sum({$<StoreCode = {'WSDP', 'WSBK', 'WSBM', 'WSMB', 'WSB1', 'WSB2'}>} SalesPrice*TransactionQuantity))

- Sum({$<StoreCode = {'WSDP', 'WSBK', 'WSBM', 'WSMB', 'WSB1', 'WSB2'}>}GrossValue-DiscountValue)

round(sum({$<Year={$(=Only(Year))}, Month={$(vPriorMonth)}, StoreCode={'WSDP', 'WSBK', 'WSBM', 'WSMB', 'WSB1', 'WSB2'}>}TransactionQuantity*SalesPrice))

- sum({$<Year={$(=Only(Year))}, Month={$(vPriorMonth)}, StoreCode={'WSDP', 'WSBK', 'WSBM', 'WSMB', 'WSB1', 'WSB2'}>}GrossValue-DiscountValue),'€ #.##0')

Re: Set analysis - text object

miguelbraga — Fri, 06 May 2016 09:43:07 GMT

Hi Rega,

Check this little change:

Num(

Num(Round(sum({$<StoreCode = {'WSDP', 'WSBK', 'WSBM', 'WSMB', 'WSB1', 'WSB2'}>} SalesPrice*TransactionQuantity))
- Sum({$<StoreCode = {'WSDP', 'WSBK', 'WSBM', 'WSMB', 'WSB1', 'WSB2'}>}GrossValue-DiscountValue))
-
Num(round(sum({$<Year={$(=Only(Year))}, Month={$(vPriorMonth)}, StoreCode={'WSDP', 'WSBK', 'WSBM', 'WSMB', 'WSB1', 'WSB2'}>}TransactionQuantity*SalesPrice))
- sum({$<Year={$(=Only(Year))}, Month={$(vPriorMonth)}, StoreCode={'WSDP', 'WSBK', 'WSBM', 'WSMB', 'WSB1', 'WSB2'}>}GrossValue-DiscountValue))

, '€ #.##0,00')

Regards,

Re: Set analysis - text object

swuehl — Fri, 06 May 2016 09:55:33 GMT

Miguel is right, the format code should show the two decimals.

But your original issue is that you have used different / missing formatting functions on the aggregations, while you should do a final formatting for the result of your calculation.