topic Re: Current Month vs Previous Month with Month Dimension in QlikView

Current Month vs Previous Month with Month Dimension

Thu, 13 Aug 2015 11:40:26 GMT

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

Re: Current Month vs Previous Month with Month Dimension

maximiliano_vel — Thu, 13 Aug 2015 11:43:55 GMT

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

Rgds

Re: Current Month vs Previous Month with Month Dimension

Thu, 13 Aug 2015 12:01:57 GMT

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

Re: Current Month vs Previous Month with Month Dimension

maximiliano_vel — Thu, 13 Aug 2015 12:08:37 GMT

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

Re: Current Month vs Previous Month with Month Dimension

Digvijay_Singh — Thu, 13 Aug 2015 12:17:11 GMT

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

Re: Current Month vs Previous Month with Month Dimension

Thu, 13 Aug 2015 13:55:40 GMT

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

Re: Current Month vs Previous Month with Month Dimension

Thu, 13 Aug 2015 14:23:56 GMT

Please find sample data.

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

Re: Current Month vs Previous Month with Month Dimension

maximiliano_vel — Thu, 13 Aug 2015 14:51:49 GMT

Please see attached file, hope it helps

Re: Current Month vs Previous Month with Month Dimension

Fri, 14 Aug 2015 10:26:22 GMT

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

Re: Current Month vs Previous Month with Month Dimension

maximiliano_vel — Fri, 14 Aug 2015 11:21:51 GMT

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.

Re: Current Month vs Previous Month with Month Dimension

Fri, 14 Aug 2015 12:46:10 GMT

I have done for month 5 and 6 but how can I expand to all months from Jan

to dec

and the ' net ' count I need to display in line chat with Month Dimension

On Fri, Aug 14, 2015 at 12:22 PM, Maximiliano Velez <

Re: Current Month vs Previous Month with Month Dimension

maximiliano_vel — Fri, 14 Aug 2015 13:02:42 GMT

Maybe this?