show just value of two last months in table or chart
I want to create a table or chart and I have "Month" as dimension, and I want to limit this dimension only by showing the last "2 months+ current month", In this case, I would like to show the data for the months of Jan,Feb,March. and they separate in two other field that show the average usage and average subscribers.
something like following pic:
would you please help me , how can set condition for them to show just 2 last month and seprate them in 2part again.
Re: show just value of two last months in table or chart
Yes a QlikView calendar, the Qlik website has a number of people's calendars. I have one I picked up from someone on a forum. I can send it through this post if you like. But in the calendar you can calculate a flag for each date to be current month, previous month etc this makes the set analysis easier as you can just select for these flags rather than building the date logic within the set analysis. This can be done but if it's a date range you want to use frequently it makes sense to add it to the calendar.
Calendar flags can also be used as filter boxes.
There's a good blog post here as a starter if you want to use set analysis