topic Re: Can a table pull data from another customized table(both the tables in front end) in QlikView

Can a table pull data from another customized table(both the tables in front end)

Tue, 07 Aug 2012 05:37:30 GMT

Hi all,

I just want to know that:

Can a table pull data from another customized table(both the tables in front end).

Regards

Sagar Gupta

Re: Can a table pull data from another customized table(both the tables in front end)

Tue, 07 Aug 2012 06:58:09 GMT

I think it's possible only by macro:/

Re: Can a table pull data from another customized table(both the tables in front end)

Tue, 07 Aug 2012 07:00:54 GMT

Hi Pari,

Thanks a LOT for ur kind Reply.

Please let me know the procedure to do so..

Also it will be of great help if you can try answering the other query too.

Regards

Sagar Gupta

Re: Can a table pull data from another customized table(both the tables in front end)

Jason_Michaelides — Tue, 07 Aug 2012 07:01:01 GMT

Can't the second table use the same dimension/expressions as the first?

Re: Can a table pull data from another customized table(both the tables in front end)

Tue, 07 Aug 2012 07:06:47 GMT

how many values you want to pull trom the second table?

and how you want to use it in the first one ?

Re: Can a table pull data from another customized table(both the tables in front end)

Tue, 07 Aug 2012 07:10:25 GMT

Hi Jason,

Thanks a LOT for the reply.

My second table will be using the same dimenssion but the expressions will be different.

The calculated metrices in my first table should act like field entry in my second table. I am doing all this to get Sparkline in my table, if you any alternate to this plzz do let me know.

I have attached a sample file which is at this location http://community.qlik.com/message/242773#242773

Regards

Sagar Gupta

Re: Can a table pull data from another customized table(both the tables in front end)

Tue, 07 Aug 2012 07:12:53 GMT

Hi Pari,

Please find attached a sample file which will help you understand my requirement.

http://community.qlik.com/message/242773#242773

Regards

Sagar Gupta

Re: Can a table pull data from another customized table(both the tables in front end)

suniljain — Tue, 07 Aug 2012 07:13:19 GMT

With the help of macro you can do that

you can export one table to excel or csv and used that excel in same application by reloading after export to excel.

Re: Can a table pull data from another customized table(both the tables in front end)

Tue, 07 Aug 2012 07:21:52 GMT

Hi Sunil,

Thanks a LOT

Is it possible to know the macro for exporting and moreover will this macro be a problem while the tool is on server

Regards

Sagar Gupta

Re: Can a table pull data from another customized table(both the tables in front end)

Tue, 07 Aug 2012 07:23:52 GMT

if both tables have the same dimension i don't understand why you want to use two separete table

can you give us more details?

Re: Can a table pull data from another customized table(both the tables in front end)

Tue, 07 Aug 2012 07:31:00 GMT

Hi Pari,

I am doing all this to get sparkline in the table.

I am not able to make sparkline coz' sparkline doesn't take calculated metrices instead it works only with field entries.

hope u r clear with the requirement

Regards

Sagar Gupta

Re: Can a table pull data from another customized table(both the tables in front end)

Tue, 07 Aug 2012 07:33:11 GMT

Hi Pari,

Is it possible for you to look into another problem, which is in below mentioned link:

http://community.qlik.com/message/245670#245670

Regards

Sagar Gupta

Re: Can a table pull data from another customized table(both the tables in front end)

suniljain — Tue, 07 Aug 2012 07:34:02 GMT

it donot disturb any other function on server. i am using this types of functionaly since more than 5 yrs but till now didi not get any probe. you can use apiguide.qvw for macro.

Re: Can a table pull data from another customized table(both the tables in front end)

suniljain — Tue, 07 Aug 2012 07:35:12 GMT

it donot disturb any other function on server. i am using this types of functionaly since more than 5 yrs but till now didi not get any probe. you can use apiguide.qvw for macro.

Re: Can a table pull data from another customized table(both the tables in front end)

Tue, 07 Aug 2012 07:37:54 GMT

Hi Sunil,

Thanks a lot for the help.

Is it possible for you to help me in my other problem, which is http://community.qlik.com/message/245670#245670

Regards

Sagar Gupta