topic Re: Total is showing Null in Table in QlikView

Total is showing Null in Table

bhavvibudagam — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

Can any one Please help me on this.

In the below table Under Duration Measure I am not able to get the Total. Its showing Null.

In the Measure if I have taken Sum(Duration) the entire Column is showing 0 so in the Measure taken direct field as Duration then getting the Values but coming to Total getting null.

Please help me to resolve the issue. Please find the attached app also.

Thanks in advance.

Re: Total is showing Null in Table

devarasu07 — Fri, 12 Jan 2018 09:26:58 GMT

Hi,

Try to apply total as "Sum" instead of expression auto total

can you share the excel file? is that duration text format then convert into number and try again.

Re: Total is showing Null in Table

Chanty4u — Fri, 12 Jan 2018 09:28:00 GMT

try this interval(sum(duration))Change Email in community

Re: Total is showing Null in Table

Chanty4u — Fri, 12 Jan 2018 09:28:46 GMT

or this

interval(Sum(Duration),'h:mm')

Re: Total is showing Null in Table

sunny_talwar — Fri, 12 Jan 2018 09:29:05 GMT

Try this

Interval(Sum(Interval#(Duration, 'h:mm')), 'h:mm')