Skip to main content
Announcements
Discover what’s possible with embedded analytics! March 6, 10 AM ET SIGN UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
madnanansari
Creator
Creator

Dividing two variables produce wrong results

I have defined the below variables in the system:

vSales1

vSales2

vTickets1

vTickets2

vSales = $(vSales1) + $(vSales2)

vTickets = $(vTickets1) + $(vTickets2)

AverageSales = ($(vSales1) + $(vSales2)) / ($(vTickets1)+$(vTickets2)) bring rights results.

where as the below formula brings wrong results:

AverageSales = $(vSales) / $(vTickets)

any idea how to resolve this?

4 Replies
hector_munoz
Specialist
Specialist

Hi Mohammad,

Have you tried AverageSales = ($(vSales)) / ($(vTickets))?

Regards,

H

sunny_talwar

Didn't you get your answer here?

Dividing variables bring wrong values

madnanansari
Creator
Creator
Author

None of the answers worked. Infact its a Qlik Sense issue instead of Qlik View. So I post it here.

madnanansari
Creator
Creator
Author

this brings wrong results