Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

How to get the quotient of a data in Qlik Sense?

 

Spoiler
 

Good Day,

 

I have below sample data in qliksense which I need to get their quotients  per dealer name, i need to do this in edit expression (measures) dealer name and balance column has the same source.

Hope someone can answer my concern. Thank you

sample data:

dealer namebalanceformulaexpected output
laguna10001000/700014.29%
makati20002000/700028.57%
batangas40004000/700057.14%
TOTAL7000  
1 Solution

Accepted Solutions
Highlighted

Re: How to get the quotient of a data in Qlik Sense?

Check this

Num(Sum(balance)/Sum(TOTAL balance), '#.#0%')

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

2 Replies
Highlighted

Re: How to get the quotient of a data in Qlik Sense?

Check this

Num(Sum(balance)/Sum(TOTAL balance), '#.#0%')

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

Highlighted

Re: How to get the quotient of a data in Qlik Sense?

Hi @Anil_Babu_Samineni 

 Data is only correct when I do filterization per month.

If display as per historical per month percentage/result s are not correct, you may refer to attached screenshots for your reference

Thank you