Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sandygather
New Contributor II

Qliksense: Need YTD and Variance column in pivot table with multiple measures

Need help to create this view in Qlik Sense Pivot table. Sample data is attached in the excel

        

Prior MonthsCurrent MonthYTDYoY%
Jun-17Jul-17Aug-17Sep-17BudgetVarianceSep-17Sep-BudgetVarianceSep-16Sep-16 v Sep-17YTD 16 v YTD 17
Con10405090110-20200210-10540-45%-63%
Churn520254555-1070155-85270-21%-74%
Upgrd624305466-1290166-76324-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.

Qliksense: Need YTD column in pivot table

stalwar1

Tags (1)
1 Reply
luismadriz
Valued Contributor

Re: Qliksense: Need YTD and Variance column in pivot table with multiple measures

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