Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Need expression or script edit for bar chart count


I'm looking to create a bar chart that gives a daily snap shot of what happened with our policy retention. The chart itself is pretty simple in that it sums or counts new policies (1+1+1+1=4) and counts or sums policies lostn (-1+-1+-1+-1=-4).

I have a list of policies on a daily basis that shows total volume and have a small example below of what is in the script



LOAD      ChannelGroup,




FROM ...

My question is what sort of edit to the script would I need to make to have a field that would have a value to count/sum on a daily basis for new policies and also a field that woould count/sum lost policies. They wouldn't be there prior to a date as a new policy is given a new pollicy number.

Any ideas?

1 Reply

Re: Need expression or script edit for bar chart count

Maybe a running total??  Try this:  http://community.qlik.com/message/272623#272623

Community Browser