topic Re: Range in QlikView

Range

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

Hi All,

I am showing a line chart with the help of range sum expression . ( The graph is showing the cummulative but not any dip )

rangeSum(above(TOTAL count({<Category={'Medium'},STATUS={'Open'}>}ID),0,RowNo(TOTAL)))
-
count({<Category={'Medium'},STATUS={'Closed'}>}ID)

And also how do I include the load date in the expression as some of the the defects closes on load date ?

How should I change the expression to get this resolved

Thanks in advance

Re: Range

smilingjohn — Mon, 30 Mar 2020 11:09:45 GMT

And I also how do i include the load date in the the expression sp that range sum trend can take the effect of the changes or the ticket close on a perticular laod date .

rangeSum(above(TOTAL count({<Category={'Medium'},STATUS={'Open'}>}ID),0,RowNo(TOTAL)))

????/ How to include the load date in the above expression

Thanks in Advance

Re: Range

Brett_Bleess — Wed, 22 Apr 2020 16:16:26 GMT

You will likely need to attach the QVW or a sample file in order for folks to provide the solution in this case.

Regards,
Brett