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.
Thanks!
David