Skip to main content

New to Qlik Sense

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

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
ioannaiogr
Creator
Creator

how to present proportion looking like this : 1:2 ?

Hello everyone 🙂 

I want to present a proportion with a  " one : many " look, maybe in a KPI?

 

Is something like that possible?

 

Thank you in advance,

Ioanna

Labels (2)
1 Solution

Accepted Solutions
marcus_sommer
MVP & Luminary
MVP & Luminary

Yes, it should be possible. Instead of using:

num(sum({< Category = {'A'}>} Sales) / sum(Sales), '#,##0.0%')

to get a normal rate you could just leave the division like:

sum({< Category = {'A'}>} Sales) & ':' & sum(Sales)

or what you probably mean with proportion with something like:

1 & ':' & num(sum(Sales) / sum({< Category = {'A'}>} Sales), '#,##0.#')

- Marcus

View solution in original post

1 Reply
marcus_sommer
MVP & Luminary
MVP & Luminary

Yes, it should be possible. Instead of using:

num(sum({< Category = {'A'}>} Sales) / sum(Sales), '#,##0.0%')

to get a normal rate you could just leave the division like:

sum({< Category = {'A'}>} Sales) & ':' & sum(Sales)

or what you probably mean with proportion with something like:

1 & ':' & num(sum(Sales) / sum({< Category = {'A'}>} Sales), '#,##0.#')

- Marcus