topic Re: Need Help with Qlikview Date function in QlikView

Need Help with Qlikview Date function

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

Hi All,

Please look into following issue and help me.

My Requirement is for a particular month I need to show the total quantity till month end of previous month.

For Ex- For country India for month June 2016(01-06-2016) the value should show

(10+30+50+70+90)=250,similarly for Month May 160

Note-The data is there for 2011 to till date

I have attached source file and qlikview file for your reference.

Regards

Tripati

Re: Need Help with Qlikview Date function

sunny_talwar — Wed, 29 Mar 2017 16:15:33 GMT

Like this?

May be this

RangeSum(Above(Sum(Quantity), 0, RowNo()))

Re: Need Help with Qlikview Date function

tripatirao — Thu, 30 Mar 2017 04:05:02 GMT

Hi Sunny

Thanks for your reply.

For country India For month June I need sum of quantity upto may month

i.e 10+30+50+70+90=250

for month May-10+30+50+70=160

Re: Need Help with Qlikview Date function

Anil_Babu_Samineni — Thu, 30 Mar 2017 04:17:01 GMT

This?

Re: Need Help with Qlikview Date function

varshavig12 — Thu, 30 Mar 2017 04:20:53 GMT

Using Sunny's exp:

RangeSum(Above(Sum(Quantity), 1, RowNo()))

Re: Need Help with Qlikview Date function

yasmeenk — Thu, 30 Mar 2017 05:58:17 GMT

Hi,

Using Sunny's Expression:

Like this?

Re: Need Help with Qlikview Date function

tripatirao — Thu, 30 Mar 2017 06:05:17 GMT

Your Solution is working for me

but thing is that user wants the report anotherway.

I have attached the image of current pivot table and expected pivot table.

Please check

Regards

Tripati

Re: Need Help with Qlikview Date function

varshavig12 — Thu, 30 Mar 2017 06:34:27 GMT

Try this:

RangeSum(before(Sum(Quantity), 1, sum(Quantity)))

Re: Need Help with Qlikview Date function

varshavig12 — Thu, 30 Mar 2017 06:40:23 GMT

May be something like this :

Re: Need Help with Qlikview Date function

sunny_talwar — Thu, 30 Mar 2017 07:53:28 GMT

Or this if you expect users to make selection in a particular month and the numbers should still stay the same

Before(RangeSum(Before(Sum({<Month>}Quantity), 0, ColumnNo()))) * Avg(1)

Without Selection

With Selection