How to write accumulation for count.....

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

Hi Team,

I am facing a this issue from long time can any one please help me out to solve this..

I am having a target tickets and resolved tickets. I need to show the Percentage of those tickets in bar chart

For Example If current month is

June then April target tickets+ May target tickets+june target tickets/total resolved tickets which includes 3 moths resolved tickets

if it is July then-April target tickets+ May target tickets+june target tickets+july target tickets/total resolved tickets which includes 4 moths resolved tickets.

Note:Nulls to be excluded

and my dimension is Month and tear fields

Can any one please help on this

Thanks,

Chinnu

Re: How to write accumulation for count.....

johnw — Wed, 12 Oct 2016 22:39:46 GMT

I'm unclear on your exact requirement, but it sounds like setting "full accumulation" might do the trick.

Another approach is to use an AsOf table.

The As-Of Table

topic How to write accumulation for count..... in QlikView

How to write accumulation for count.....

Re: How to write accumulation for count.....