Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

anguila
Contributor

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?

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

Community Browser