Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi Mohammad,
Have you tried AverageSales = ($(vSales)) / ($(vTickets))?
Regards,
H
Didn't you get your answer here?
None of the answers worked. Infact its a Qlik Sense issue instead of Qlik View. So I post it here.
this brings wrong results