Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
qlikhans
Contributor

derive period from date and column heading

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 1Header 2Header 3Header 4Header 5Header 6Header 7Header 8
0102janfeb
ActualPlanActualPlanActualPlanActualPlan

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

2 Replies

Re: derive period from date and column heading

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.


talk is cheap, supply exceeds demand
marcarreras
Valued Contributor

Re: derive period from date and column heading

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.

Community Browser