Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have 2 files. File 1 is actual transactions in csv. File 2 is excel converted in QV to a crosstable.
File 1 has transaction dates dd-mm-yyyy.
File 2 has period numbers as column headers: 01, 02,03 etc.
when creating a pivot table in QV I get columns such as
Header 1 | Header 2 | Header 3 | Header 4 | Header 5 | Header 6 | Header 7 | Header 8 |
---|---|---|---|---|---|---|---|
01 | 02 | jan | feb | ||||
Actual | Plan | Actual | Plan | Actual | Plan | Actual | Plan |
Where 01=jan and 02=feb
changing headings in excel to jan, feb etc does not solve my problem
who can help me to solve this issue?
krgrds Hans
Het bericht is bewerkt door: Hans kleijnen
Can you describe what the issue is? What is the result you want to see? A qlikview document and example source files would be helpful.
I understand you want to convert your 01,02... month number field in text content. In this case try this:
Pick(num(yourmonthnumberfield),'jan','feb','mar','abr','may','jun','jul','aug','sep','oct','nov','dec')
Marc.