topic Re: bring excel pivot data to QV in QlikView

bring excel pivot data to QV

vireshkolagimat — Wed, 13 Apr 2016 03:57:20 GMT

Hi Guys,

I have some data which is uploaded to the sharepoint in excel file as below. I need to bring the data as is in excel or other way but finally i should get the same look in Qlikview once i bring the data into qlikview. Please help me to this.

and also some time the range might change so i need some solution what if range is changed.

Is there any way i can create a front end application, the user can provide the input and Qlikview can store it.

below is the screenshot for your reference.

thanks in advance.

Regards,

Viresh

Re: bring excel pivot data to QV

Gysbert_Wassenaar — Wed, 13 Apr 2016 08:10:28 GMT

Is there any way i can create a front end application, the user can provide the input and Qlikview can store it.

Yes, but the front end application already exists. It's called MS Excel. Enter your data in an excel file and load the data into Qlikview.

Can you post an excel file with example data?

Re: bring excel pivot data to QV

vireshkolagimat — Wed, 13 Apr 2016 09:46:38 GMT

Hi, the data is already available in excel sheet. how to load this excel file.

I tried to load it as normal excel file but i can't.

Regards,

Viresh

Re: bring excel pivot data to QV

vireshkolagimat — Wed, 13 Apr 2016 09:55:42 GMT

sample data:

Week Ending	Month	Quarter	Year to Date
1-Jan	To Date	To Date	2016	2015	Budget
Investment Banking	1	2	3	5	7	8
Merchant Banking	3	6	9	4	7	9
Fixed Income Curr. & Comm.	3	6	8	3	5	7
Equities	4	6	1	4	9	1
Securities	2	4	6	8	3	6
Investment Management	5	7	9	2	6	8
Unallocated	1	5	8	9	3	1
Net Revenues	19	36	44	35	40	40

Re: bring excel pivot data to QV

Gysbert_Wassenaar — Wed, 13 Apr 2016 11:22:33 GMT

See attached example.

Re: bring excel pivot data to QV

vireshkolagimat — Wed, 13 Apr 2016 11:36:23 GMT

Hey, sorrry i am not able to see the attachment.

Re: bring excel pivot data to QV

Gysbert_Wassenaar — Wed, 13 Apr 2016 16:27:44 GMT

You can find the attachment to the right of the paperclip icon:

Re: bring excel pivot data to QV

Peter_Cammaert — Wed, 13 Apr 2016 17:23:22 GMT

Do not view this thread in your Inbox or on a mobile device. They won't show any attachments. In your browser, click the blue discussion header to open a full thread view and navigate to Gysbert's answer. Your attachment will show up allright.

Peter