Re: sum of total - Qlik Community

Report Inappropriate Content · ‎2016-02-22

Hi there,

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

example show in excel pivot table

sunny_talwar · ‎2016-02-22

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

Report Inappropriate Content · ‎2016-02-24

Hi Sunny,

i got "-"

pls see the screen shot.

Chanty4u · ‎2016-02-24

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

Or try ur single expression in text box

=sum(Total X)

=sum(Total Y)

Digvijay_Singh · ‎2016-02-24

Please share sample data to understand the issue. Thanks.

PrashantSangle · ‎2016-02-24

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.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Report Inappropriate Content · ‎2016-02-24

hi all,

Pls see the attached file.

sunny_talwar · ‎2016-02-24

Can you share the application by any chance?

Report Inappropriate Content · ‎2016-02-24

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.

Chanty4u · ‎2016-02-24

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

PFA