Discussion board where members can get started with QlikView.
How can i do a sum of total X / sum of total Y
example show in excel pivot table
Your expression seems right, is it not doing what it is supposed to?
i got "-"
pls see the screen shot.
=sum((Total X)/(Total Y))
Or try ur single expression in text box
Please share sample data to understand the issue. Thanks.
check values for field CT,PM_WAIT_TIME_Q and CNTR_N In list box.
did you get values for these 3 fields????
Pls see the attached file.
Can you share the application by any chance?
I have attached the qvw file.
Or you can look at my excel file, it is what i trying to do for the yellow box.
hi chk below...ur sum(CNTR_N) values is '0' so its nt gettng correct.