Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Ken_Hardwick
Contributor III
Contributor III

Number formatting not allowing anything other than Auto

Hello,

When I include the formula sum({<Year = {'2019'}>} Qty*Pricing) and the formula sum({<Year = {'2020'}>} Qty*Pricing) into my report I am able to change the number formatting however I wish. I have this set to money.

As soon as I include the formula sum({<Year = {'2020'}>} Qty*Pricing) - sum({<Year = {'2019'}>} Qty*Pricing) I am unable to change the number formatting from Auto. What is in this formula that is causing issues?

Thanks

3 Replies
Kush
MVP
MVP

Which chart you are using? What are the dimensions?

Vegar
Partner
Partner

I don't see why you shouldn't be able to format your expression to anything other than Auto.

An workaround to this problem could be to define the format in the expression like this :

Money( sum({<Year = {'2020'}>} Qty*Pricing) - sum({<Year = {'2019'}>} Qty*Pricing) 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Ken_Hardwick
Contributor III
Contributor III
Author

I am using a pivot table that is looking at sales by week in 2019 and 2020 & looking at the change YoY. 

Ken_Hardwick_0-1593985672343.png