Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Current Month vs Previous Month with Month Dimension

 

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
523166527255
2015050527255
201506523166

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
201505527255
201506523166

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

11 Replies
Partner
Partner

Re: Current Month vs Previous Month with Month Dimension

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

Rgds

Not applicable

Re: Current Month vs Previous Month with Month Dimension

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

Partner
Partner

Re: Current Month vs Previous Month with Month Dimension

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

Digvijay_Singh
Honored Contributor III

Re: Current Month vs Previous Month with Month Dimension

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

Not applicable

Re: Current Month vs Previous Month with Month Dimension

Hi

Please find sample data

   

NM CountMonthIDMonthYear
120150552015
120150662015
120150552015
120150662015
120150662015
120150552015
120150662015
120150552015
120150662015
120150552015
120150552015
120150662015
120150552015
120150662015
120150552015
120150662015
120150552015
120150662015
120150552015
120150662015
120150552015
120150552015
120150662015
120150552015
120150662015
120150552015
120150662015
120150552015
120150552015
120150662015

Result How I am getting in qlikview

   

MonthID201505201506
Month 6 Closing Count 014
month 6 Opening Count ( Month  5 Clossing Count)160
Net-1614

Result how I want

   

MonthID201506
Month 6 Closing Count 14
month 6 Opening Count ( Month 5 Clossing Count)16
Net-2
Not applicable

Re: Current Month vs Previous Month with Month Dimension

Hi

Please find sample data.

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

Partner
Partner

Re: Current Month vs Previous Month with Month Dimension

Please see attached file, hope it helps

Not applicable

Re: Current Month vs Previous Month with Month Dimension

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

Partner
Partner

Re: Current Month vs Previous Month with Month Dimension

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.