Skip to main content
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
Not applicable
Author

Hi

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 <

maximiliano_vel
Partner - Creator III
Partner - Creator III

Maybe this?