topic Store data into excel in QlikView

Store data into excel

jagannalla — Thu, 19 May 2011 11:10:02 GMT

Hi,

- I had an excel sheet with 3 columns i.e ID(primary Key), MinValue,MaxValue.

- My default in excel sheet i had data for ID column upto 10 rows and there is no data for MInvalue & MaxValue columns.

The following is my Task in Qlikview:

- I had two inbut boxes with two varibables i.e vMinValue, vMaxValue.

- I had list box with ID.

The ID field is taken from excel sheet.

- Now when i click the button the variables vMinValue should stored under Minvalue and vMaxValue should stored under MaxValue columns of excel sheet based on selection of ID in the list box i.e it should store under particular ID only.

How can i do this? Is it possible to do?

Store data into excel

kaushiknsolanki — Thu, 19 May 2011 11:17:44 GMT

Hi,

Yes it is possible.

You can achieve this by using macros to export data to existing excel sheet.

Regards,

Kaushik Solanki

Store data into excel

jagannalla — Thu, 19 May 2011 12:51:14 GMT

how can i do this can you help me.

Re: Store data into excel

kaushiknsolanki — Fri, 20 May 2011 11:58:44 GMT

Hi,

I am here by uploading an example.

Have a look at that

Regards,

Kaushik Solanki

Re: Store data into excel

Thu, 07 Mar 2013 13:41:23 GMT

Hi Kaushik,

I gave the Full Path of the Excel File in the macro but the document opens without any change.

What else?

ThankYou very very much!