topic Re: Set Analyis with current month and previous month in QlikView

Set Analyis with current month and previous month

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

Dear All,

Please help me find out the required output.

I have attached the output what i want and the source file.

And also want the YTD value of corrosponding product.

Please do the needful.

Regards

Tripati

Re: Set Analyis with current month and previous month

Anonymous — Mon, 07 Nov 2016 12:15:37 GMT

Try :

expression:

Sum( {<Year=,Month= ,Week =,Day=, DataNum={">=$(=Num(YearStart(Today())))<=$(=Num(Today()))"}>} Sales)

Check aswell:

Previous YTQ, QTD, MTD and WTD

Regards,

Grzegorz

Re: Set Analyis with current month and previous month

sunny_talwar — Mon, 07 Nov 2016 12:23:25 GMT

This doesn't match you exact output, but is this what you were looking to get?

Re: Set Analyis with current month and previous month

miskin_m — Mon, 07 Nov 2016 12:30:06 GMT

Hi,

try below

sum(Sales)-sum(aggr(above(sum(Sales)),Product,date))

Regards,

Re: Set Analyis with current month and previous month

tripatirao — Mon, 07 Nov 2016 12:38:38 GMT

Dear Sunny,

Thanks for reply.

This is some what is matching my requirement.Can I have code for YTD.

means If I select a month APR ,sales of a particular product from JAN to APR.

Please help me for YTD.

Regards

Tripati

Re: Set Analyis with current month and previous month

arulsettu — Mon, 07 Nov 2016 12:44:36 GMT

maybe try this

sum({<month={'>=$(=YearStart(date(max(month))))<=$(=max(month))'}>}sales)

Re: Set Analyis with current month and previous month

sunny_talwar — Mon, 07 Nov 2016 13:00:13 GMT

Like this?

Re: Set Analyis with current month and previous month

tripatirao — Mon, 07 Nov 2016 13:16:10 GMT

Dear Sunny

Thanks for reply

If I select Apr the value for Pen will be 280.

i.e. 100+50+30+100

Please check the excel for your reference and do the needful.

Regards

Tripati

Re: Set Analyis with current month and previous month

tripatirao — Mon, 07 Nov 2016 14:18:14 GMT

Dear Sunny

Please help me to find the YTD.

Regards

Tripati

Re: Set Analyis with current month and previous month

sunny_talwar — Mon, 07 Nov 2016 16:46:48 GMT

Your first Excel file showed a different output. May be try the attached:

Re: Set Analyis with current month and previous month

tripatirao — Tue, 08 Nov 2016 12:11:21 GMT

Dear Sunny,

I got my requirement as attached image.

Please Help me to find out the YTD.

For example for MAY for product PEN it should be

100+(-50)+(-20)+70+(-90)=10

For example for Apr for product PEN it should be

100+(-50)+(-20)+70=100

I have shared the sample data along with my requirement YTD.

Please check and do the needful.

Regards

Tripati