Re: Drill through on fact columns in qlikview by p... - Qlik Community

Report Inappropriate Content · ‎2013-02-22

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.

Gysbert_Wassenaar · ‎2013-02-22

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

talk is cheap, supply exceeds demand

Report Inappropriate Content · ‎2013-02-24

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?

phaneendra_kunc · ‎2013-02-24

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..

Report Inappropriate Content · ‎2013-02-25

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.

phaneendra_kunc · ‎2013-02-25

Is it possible to post a sample applications?

Report Inappropriate Content · ‎2013-02-25

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.

phaneendra_kunc · ‎2013-02-25

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

sushil353 · ‎2013-02-25

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

Report Inappropriate Content · ‎2013-02-26

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?

Drill through on fact columns in qlikview by passing parametre