Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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