0 Replies Latest reply: Jul 31, 2013 1:02 PM by David Alcobero Pinyot RSS

    Export pivot table with dual dimension as numeric to Excel but keeping text in qlikview

    David Alcobero Pinyot

      Hi,

       

      I have a pivot table with a dual dimension (YearMonth, i.e: Jan'2013 - 201301 ) and some expresions. It's nice to see the text value when working in qv but when working in excel it's better and easier work with numbers.. So I'm wondering if there's a way to keep both, but text in qv and numeric in excel. Maybe with a macro?

       

       

      KindMonthEur
      Ajun'131
      Bjun'132
      Cjun'133
      Djun'134

       

      And I want:

       

      KindMonthEur
      A2013061
      B2013062
      C2013063
      D2013064

       

       

       

      I found this thread ( http://community.qlik.com/thread/35380 ) and I want to do the "opposite" thing (not exactly..) , but the file it's a good-working demonstration of what I want to achieve.

       

       

      Thanks!

       

       

      David