Export pivot table with dual dimension as numeric to Excel but keeping text in qlikview
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?
Kind
Month
Eur
A
jun'13
1
B
jun'13
2
C
jun'13
3
D
jun'13
4
And I want:
Kind
Month
Eur
A
201306
1
B
201306
2
C
201306
3
D
201306
4
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.
