Discussion Board for collaboration on QlikView Scripting.
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
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?
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: