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
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Value list dimension for multi kpi, change formatting

Hi. 

I have a multi kpi and I'm using a value list for the dimension. In the measures, I have specific calculations for each valuelist item, but I was wondering if it is possible to set a different format pattern for one of them because I have a ratio field that is 0.56 but it rounds to 1.

Labels (1)
1 Solution

Accepted Solutions
Master III
Master III

8 Replies
Master III
Master III

Use num function on your every measure based on you need for example

num(Sum(expression),'#.##') = 1234.56

Contributor III
Contributor III

What would be the formatting for 0.56? 

Master III
Master III

Try the above

Contributor III
Contributor III

Not sure why in the multi kpi it still rounds to 1, but if i display it separately it is the decimal

Master III
Master III

Can you provide sample app

Contributor III
Contributor III

I have created some sample data

Master III
Master III

Contributor III
Contributor III

Not sure why it doesn't work in my actual app but since it works in the example, it might help other people. Thank you, I'll try exploring