topic Re: some question about qlikview in QlikView

some question about qlikview

Tue, 25 Dec 2012 05:16:50 GMT

hi all

please help me.im new in qlikview.

How can get data shared between two query?

how we can add column without define in query?

and when we have two column(debit and credit), how we can get the balance of debt during the first term and add as column ???

thanks

Re: some question about qlikview

er_mohit — Wed, 26 Dec 2012 06:37:30 GMT

for the purpose of data sharing use binary function which reload all data of 1qvw file into another

and in concern of adding column use inline function for define that column virtually not actul

and for last using pivot table and write the expression

sum(distinct debt )/sum(total <year>debt).

hope it helps you..for last query i didnot get you exactly..

Re: some question about qlikview

Sat, 29 Dec 2012 06:34:19 GMT

Thank YOU for guidance and clarification of key points.

But can you please guide me how can I upload a QVW in another QVW?

Re: some question about qlikview

Sat, 29 Dec 2012 07:47:59 GMT

Add an action (External->Open Qlikview Document) to your button that opens qvw2 and check the option Transfer State. That way selections in qvw1 will be applied to qvw2 when it is opened. If you have different schenario then write it here.

Re: some question about qlikview

Mon, 31 Dec 2012 10:51:07 GMT

Thank You .