Current Month vs Previous Month with Month Dimension

[#1]

Hi Qlikview Friends

I Can do this In qikview

MonthID is Dimension , NM Counts are count of 201505, 201506 MonthIDs Respectivelly,  Am using set analysis to get fallowing chat in qlikview  Count({$<MonthID = {'201505'}>}member), Count({$<MonthID = {'201506'}>}member)

MonthID	NM Count	NM Count
	523166	527255
201505	0	527255
201506	523166	0

I Can Not able to Do Fallowing

I Have a requirement as fallows , I need to display data as for requirement like MonthID Dimemsion which is same as above and NM Counts need to get in one single column instead of two separate columns  and totals need to come,

MonthID	NM Count
	1050421
201505	527255
201506	523166

  Help me Is this Possible in qlikview or not I dought about it, its urget requirement

[maximiliano_vel]

If your MonthID is your dimension, then you could try Count(member) without the set analysis.

Rgds

[#3]

Hi Maximiliano

I Have Month, MonthID  as dimensions,

Its coming same when I use 201505 or 05 as dimension

201505 (527255)  is previous monthID Member count , which is opening count for Current Month 201506.

201506(523166)  is Current MonthID  Member count

I need NET = 523166 - 527255 = - 4089  I need As Result set

[maximiliano_vel]

Perhaps you could post some data to see in more detail your requirement?

[Digvijay_Singh]

Try to get above value like Count(member)-Peek(NM Count), or post some sample data.

[#6]

Hi

Please find sample data

NM Count	MonthID	Month	Year
1	201505	5	2015
1	201506	6	2015
1	201505	5	2015
1	201506	6	2015
1	201506	6	2015
1	201505	5	2015
1	201506	6	2015
1	201505	5	2015
1	201506	6	2015
1	201505	5	2015
1	201505	5	2015
1	201506	6	2015
1	201505	5	2015
1	201506	6	2015
1	201505	5	2015
1	201506	6	2015
1	201505	5	2015
1	201506	6	2015
1	201505	5	2015
1	201506	6	2015
1	201505	5	2015
1	201505	5	2015
1	201506	6	2015
1	201505	5	2015
1	201506	6	2015
1	201505	5	2015
1	201506	6	2015
1	201505	5	2015
1	201505	5	2015
1	201506	6	2015

Result How I am getting in qlikview

MonthID	201505	201506
Month 6 Closing Count	0	14
month 6 Opening Count ( Month  5 Clossing Count)	16	0
Net	-16	14

Result how I want

MonthID	201506
Month 6 Closing Count	14
month 6 Opening Count ( Month 5 Clossing Count)	16
Net	-2

[#7]

Hi

Please find sample data.

On Thu, Aug 13, 2015 at 1:18 PM, Digvijay Singh <qcwebmaster@qlikview.com>

[maximiliano_vel]

Please see attached file, hope it helps

[#9]

Hi Qlikview Friends

Thank you so much to Maximiliano and Digvijay for Your Quick response,

I am done Now.

Regards

NKummari

On Thu, Aug 13, 2015 at 3:52 PM, Maximiliano Velez <qcwebmaster@qlikview.com

[maximiliano_vel]

We are glad to here that, please close this thread by marking the correct and any helpful answers so that it can be useful for other people.