Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
maximiliano_vel
Partner - Creator III
Partner - Creator III

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

Rgds

Not applicable
Author

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
Partner - Creator III
Partner - Creator III

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.

Not applicable
Author

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
Author

Hi

Please find sample data.

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

maximiliano_vel
Partner - Creator III
Partner - Creator III

Please see attached file, hope it helps

Not applicable
Author

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
Partner - Creator III
Partner - Creator III

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.