topic Re: Drill through on fact columns in qlikview by passing parametre in QlikView

Drill through on fact columns in qlikview by passing parametre

Fri, 22 Feb 2013 12:29:18 GMT

Hi All,

I'm trying to achieve drill through on one fact in straight table, by passing the value of selected fact and selected dimension while drilling through to new qlikview document.

Re: Drill through on fact columns in qlikview by passing parametre

Gysbert_Wassenaar — Fri, 22 Feb 2013 12:35:00 GMT

You can open another qlikview document and apply your selections to that document by adding an Open Qlikview Document action to a button (or text object) and checking the option Transfer State. See this discussion for an example

Re: Drill through on fact columns in qlikview by passing parametre

Mon, 25 Feb 2013 04:34:09 GMT

But what I want is when I clicked on one of the fact, it should open other Qlikview document with more detail about that selected fact and dimension. I want any button should come in picture. Is there any way that I can pass parameter of the selected fact to other Qlikview document?

Re: Drill through on fact columns in qlikview by passing parametre

phaneendra_kunc — Mon, 25 Feb 2013 04:59:55 GMT

May be i am missing something here...

Selecting on a fact means..are u trying to select the expression value from a straight table or Pivot table..

Or a list boxes?

Why i am asking is becoz..if you are selecting the expression value from a straight table then it will selects the entire row..which u probably dont want..

Re: Drill through on fact columns in qlikview by passing parametre

Mon, 25 Feb 2013 05:08:21 GMT

Hi,

I’m trying to select expression value from straight table.

Mean I have one straight which contains field as study status query performance,% reissued queries and some more.

What I want is if user click on the query performance expression of table it will open new Qlikview document which will show the study, and more details of the fact query performance,

My issue is how will I know that user has selected the fact query performance and how can I pass this value to other document.

Re: Drill through on fact columns in qlikview by passing parametre

phaneendra_kunc — Mon, 25 Feb 2013 05:21:00 GMT

Is it possible to post a sample applications?

Re: Drill through on fact columns in qlikview by passing parametre

Mon, 25 Feb 2013 05:58:56 GMT

Hi,

Here attached is main document, when I clicked on the expression % of Queries reissued, it will open second document with selected trial in main document and having details regarding that fact.

Re: Drill through on fact columns in qlikview by passing parametre

phaneendra_kunc — Mon, 25 Feb 2013 06:28:05 GMT

Ok Gotcha...

U are trying to open the Query Doc if you click on the %Queries Reissued header/Values...

Possible way is below:

One way of doing that is to have a text object with open doc action...

This is how it will work...

1. Place a transparent text box with the Open QV doc action

2. Enable transfer state and add the QV doc name that you are trying to open when u click on the header.

Attached is the sample

Re: Drill through on fact columns in qlikview by passing parametre

sushil353 — Mon, 25 Feb 2013 06:53:29 GMT

Hi,

you can achieve this using a button. first of all get the selections. and then pass the information to open another file.

PFA.

HTH

Sushil

Re: Drill through on fact columns in qlikview by passing parametre

Tue, 26 Feb 2013 05:50:20 GMT

I want to know which fact is selected along with the dimensions selected.

And how can I pass the current selection to the new document?

Re: Drill through on fact columns in qlikview by passing parametre

phaneendra_kunc — Fri, 01 Mar 2013 05:21:45 GMT

As long as if you are maintaining same column names then by enabling the option called transfer state will pass the current selections on a button click..

Re: Drill through on fact columns in qlikview by passing parametre

Tue, 24 Nov 2015 15:12:52 GMT

Hi Wassenaar

Can you please tell me where I can find Transfer state option, I'm looking to do drill through from one sheet to another

Thanks