Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Need help to create this view in Qlik Sense Pivot table. Sample data is attached in the excel
| Prior Months | Current Month | YTD | YoY% | |||||||||
| Jun-17 | Jul-17 | Aug-17 | Sep-17 | Budget | Variance | Sep-17 | Sep-Budget | Variance | Sep-16 | Sep-16 v Sep-17 | YTD 16 v YTD 17 | |
| Con | 10 | 40 | 50 | 90 | 110 | -20 | 200 | 210 | -10 | 540 | -45% | -63% |
| Churn | 5 | 20 | 25 | 45 | 55 | -10 | 70 | 155 | -85 | 270 | -21% | -74% |
| Upgrd | 6 | 24 | 30 | 54 | 66 | -12 | 90 | 166 | -76 | 324 | -27% | -72% |
This seems similar in approach to solution mentioned in below blog. However I am new to QlikSense and not able to adjust this to my requirement.
Hi Sandeep, I uploaded a document that deals with the subject for Qlik Sense. Please take a look as I think it could be helpful for you: My 2 cents on Time Analysis
Cheers,
Luis