JD Edwards Qlikview

[shalensookdeo]

Hi All 

Please can i have some advise on the attached file. This is data that feeds from JD Edwards.

In the columns the months are in the format of (Net Posting 01) which is July and (Net Posting 02) which is Aug and (Net Posting 3) which is Sep on so on.

How can load the data into qlikview so that i can select month July for example and see my totals.

I have tried a cross table and lose some columns after loading.

Any sample files would be appreciated.

[Shubham_Deshmukh]

Have you tried Case WHen in SQL script

[shalensookdeo]

HI
Yes i have tried, the data is same in SQL.
Thanks

[Shubham_Deshmukh]

Let me understand your requirement, you have Net Posting 01,Net Posting 02 instead of Month names.So you just want to replace the same by month names ?
If yes, then case when should work in your case.

[shalensookdeo]

Yes and also be able to select each month separately on my selections to see the totals.

[Shubham_Deshmukh]

Hi,
So whats an issue? Show me your case when.
Ya, once you got your mapping correct, filter will work as you want.

[shalensookdeo]

How would you map this ? I am having trouble with making the months a selectable filter.
Thanks

[Shubham_Deshmukh]

Firstly use proper Case When in your script for proper association with all data, 

Case 

When field='Net Posting 01' then 'Jul'

When field='Net Posting 02' then 'Aug'

When field='Net Posting 03' then 'Sep'

.

.

end as 'month';

Use month in list box.

[abednego]

Hi

When you load the excel file, rename the headings to whatever month you desire. I noticed that you have 14 months instead of 12 and this could be the reason why you lose data when you import two columns with the same name. I also noticed that the same header names appear with 'Debit' in them. Attached is my sample import of your file.

[shalensookdeo]

Hi Abednego
Thank you for the assistance but how would i select each month for example if i select just July as a selection or if i want to select July and August Even if i need to create another excell table with the months?
Thanks