Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

sum of total

Hi there,

How can i do a sum of total X / sum of total Y

example show in excel pivot table

18 Replies
Highlighted

Re: sum of total

Your expression seems right, is it not doing what it is supposed to?

Highlighted
Not applicable

Re: sum of total

Hi Sunny,Capture.PNG

i got "-"

pls see the screen shot.

Highlighted
Champion III
Champion III

Re: sum of total

=sum((Total  X)/(Total Y))

Or try ur single expression in text box

=sum(Total X)

=sum(Total Y)

Highlighted
Master III
Master III

Re: sum of total

Please share sample data to understand the issue. Thanks.

Highlighted

Re: sum of total

Hi,

check values for field CT,PM_WAIT_TIME_Q and CNTR_N In list box.

did you get values for these 3 fields????

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Highlighted
Not applicable

Re: sum of total

hi all,

Pls see the attached file.

Highlighted

Re: sum of total

Can you share the application by any chance?

Highlighted
Not applicable

Re: sum of total

Hi Sunny,

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.

Highlighted
Champion III
Champion III

Re: sum of total

hi chk below...ur sum(CNTR_N)  values is '0'  so its nt gettng correct.

PFA