4 Replies Latest reply: May 1, 2012 10:51 AM by lidojuagon RSS

    Toggle expression in pivot table

      I'm new to the community and QlikView.  I searched but unfortunately I didn't find exactly what I was looking for. 

       

      I have a model with a pivot table that compares expressions that are typically actual, budget and forecast.  So for any one table we compare, actual to budget, or forecast to actual or forecast to budget.  Is there a way I can dynamically change the columns between actual, budget or forecast. 

       

      I was using set analysis.  Below is the one for budget:

       

      (Sum({$<balance_code={'BUDGET'}>} Amounts))

       

      So I basically want 'Budget' to toggle.  I think I can do it with a button, but ideally I would like a drop box in the pivot table.  Not sure if QlikView can do the later.