Re: [Qlik Sense] Set Analysis Last Month in pivot table
When you use month as a dimension you are not able to display last month's value in current month's column simply because set analysis is ment to define a dataset considered for chart calculation. It is evaluated before the chart is rendered only to establish which data will be used for that particular chart and which will not. Only after evaluating the set analysis the data is aggregated based on dimensions. The reason why the result of your measure is zero in some months is that the intersection of that month's data and your set analysis is empty data set, therefore nothing to aggregate => 0.
But don't worry, there are ways how to achieve your goal. One is suggested by stalwar1 in previous comment (using Before() function), which will not work on the first column, the other is building As-Of calendar table as described here: The As-Of Table