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.
vireshkolagimat
Contributor II

bring excel pivot data to QV

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.

Bring to QV.PNG

thanks in advance.

Regards,

Viresh

Tags (1)
7 Replies

Re: bring excel pivot data to QV

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?


talk is cheap, supply exceeds demand
vireshkolagimat
Contributor II

Re: bring excel pivot data to QV

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

vireshkolagimat
Contributor II

Re: bring excel pivot data to QV

     sample data:

Week EndingMonthQuarterYear to Date
1-JanTo DateTo Date20162015Budget
Investment Banking123578
Merchant Banking369479
Fixed Income Curr. & Comm.368357
Equities461491
Securities246836
Investment Management579268
Unallocated158931
Net Revenues193644354040

Re: bring excel pivot data to QV

See attached example.


talk is cheap, supply exceeds demand
vireshkolagimat
Contributor II

Re: bring excel pivot data to QV

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

Re: bring excel pivot data to QV

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

comm213091.png


talk is cheap, supply exceeds demand

Re: bring excel pivot data to QV

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

Community Browser