Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikhans
Creator
Creator

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
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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
Anonymous
Not applicable

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.