Qlik Community

Qlik Sense App Development

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

madnanansari
New Contributor III

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?

Tags (1)
4 Replies
hector_munoz_in
Valued Contributor

Re: Dividing two variables produce wrong results

Hi Mohammad,

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

Regards,

H

Re: Dividing two variables produce wrong results

Didn't you get your answer here?

Dividing variables bring wrong values

madnanansari
New Contributor III

Re: Dividing two variables produce wrong results

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

madnanansari
New Contributor III

Re: Dividing two variables produce wrong results

this brings wrong results

Community Browser