topic Cumulative Total in QlikView

Cumulative Total

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

stalwar1‌

Hi Sunny, i am not able to attach the qvw in our previous blog so i created new one. please find the attachmen

thanks ,

hima

https://community.qlik.com/thread/291324

Re: Cumulative Total

sunny_talwar — Thu, 15 Feb 2018 12:38:38 GMT

Try this

=RangeSum(Before((count({$<SHIPPED_DATE={'*'}>}DISTINCT ITEM))/(count(TOTAL <YearQuarter>{$<CREATION_DATE={'*'}>}DISTINCT ITEM)), 0, ColumnNo()))

Re: Cumulative Total

himabinduch — Thu, 15 Feb 2018 12:57:30 GMT

Hi Sunny,

amazing

your blogs always helps me a lot.

its absolutely working fine, can i create rolling quarters for this. i mean in Reporting Periods part only??

and one more i need is there are few items which are not been shipped yet its coming under quarter Q how can i avoid that

Re: Cumulative Total

sunny_talwar — Thu, 15 Feb 2018 13:11:40 GMT

Can you elaborate on your requirements? May be provided the output you expect to see in QlikView

Re: Cumulative Total

himabinduch — Thu, 15 Feb 2018 13:46:36 GMT

sorry may be was not clear

i want to avoid the Q quarter in the below data. we are getting that Q value due to null values present in the data. but in the shipped count we should show that

i am unable to share the data so i shared the above screenshot.

Re: Cumulative Total

sunny_talwar — Thu, 15 Feb 2018 14:42:23 GMT

Are you using a calculated dimension for the dimension at the top?

Re: Cumulative Total

himabinduch — Thu, 15 Feb 2018 15:22:38 GMT

no i just created year and quarter on that field if see in my script you will find that

Re: Cumulative Total

sunny_talwar — Thu, 15 Feb 2018 15:26:14 GMT

May be use a set analysis to exclude it

{<YearQuarter -= {'Q'}>}

Re: Cumulative Total

himabinduch — Fri, 16 Feb 2018 06:03:45 GMT

Hi Sunny,

i implemented the same in my expression but it is not working. still the Q is appearing in my data is there any chance to remove that.

Re: Cumulative Total

sunny_talwar — Fri, 16 Feb 2018 10:34:05 GMT

What are your dimensions and what expression did you use?

Re: Cumulative Total

himabinduch — Fri, 16 Feb 2018 11:22:48 GMT

there are few nulls in the data so it is coming like that. i changed that now it is coming properly but now its became challenge for me to create rolling quarters in the app can i get any suggestion for that.

Re: Cumulative Total

sunny_talwar — Fri, 16 Feb 2018 11:23:33 GMT

I am not 100% sure I follow....

Re: Cumulative Total

himabinduch — Fri, 16 Feb 2018 11:43:58 GMT

Thanks For your Help

Re: Cumulative Total

sunny_talwar — Fri, 16 Feb 2018 11:50:18 GMT

Sure