topic DAta Extraction with Qlikview in QlikView

DAta Extraction with Qlikview

Wed, 20 Apr 2011 09:05:15 GMT

Hi community.

I have a serious problem, and i wish your opinion to progress.

I have two tables that i load with the followings statements:

formule:
LOAD IDFORMULE,
DEBCPTE,
FINCPTE,
LIBGPE,
LIBSGPE,
LIBSSGPE,
LIBSSSGPE,
LIBRUB,
SENS,
LIBDETAIL
FROM

(biff, embedded labels, table is Sheet1$);

ecriture:
LOAD CDOS,
NUMCPT,
SENS,
MONTANT,
DATEECR,
PERIODE,
MOIS,
ANNEE,
TRIMESTRE,
NUMCPT1,
NUMCPT2,
NUMCPT3,
NUMCPT4
FROM

(biff, embedded labels, table is Sheet1$);

The table "Formule" allowed me to build the following PivotTable:

The expressions that can fill the columns of months, I built it in strings.
What I wish to make is this:
I wish that when you click on an amount that some table information is displayed in a TABLE or in a TEXT object. Preferably, the information that helped figure out the amount that appears.

Thank you

DAta Extraction with Qlikview

Anonymous — Wed, 20 Apr 2011 09:29:05 GMT

Hi Yimen,

When you select an amount, does it filter any of the dimensions to only one value?

You can create a second table/text box with all the data, but use conditional show to make it visible only when one value is selected (of a field from the 1st one):

if ( count ( distinct FieldFromTable1 ) = 1, 1, 0 )

Or if you want it to be visible on any selection within a field, you can use:

if ( getselectedcount ( FieldFromTable1 ) >=1 )

Let me know if it helps,

Dilyana

Dilyana Ivanova
Consultant, CapricornVentis
QlikView Elite Partner

Re. :Re: DAta Extraction with Qlikview

Wed, 20 Apr 2011 09:39:31 GMT

Please Dilyana.

Can i have an example ?

Thanks

DAta Extraction with Qlikview

Anonymous — Wed, 20 Apr 2011 10:44:17 GMT

I can't open your attachment, so I'm not sure this is what you need, but in this file you can see example of conditional show

(it's a setting in object properties / layout)

Re. :Re: DAta Extraction with Qlikview

Wed, 20 Apr 2011 11:15:18 GMT

Thanks Dilyana, that's exactly what i want.

Please Can you explain me this statement:

=if(count( distinct Month)=1,1,0) ?

Thanks

Re. :Re: DAta Extraction with Qlikview

Anonymous — Wed, 20 Apr 2011 11:25:51 GMT

It just checks if the user has narrowed the selection to only one value in the 'Month' field. You should use your field (dimension) of course. In this example, month is just a field name. The point is to show the second table only when it displays info about one particular month only.

Did you check the file? Is this the effect you'd like to achieve eventually?

Re. :Re: Re. :Re: DAta Extraction with Qlikview

Wed, 20 Apr 2011 11:33:54 GMT

Yes i have checked the file, it's effectively this effect iwant.

But the problem is that, the expression that i use in my columns is built from the qlikview script.

That is: there is no link between the columns (Janvier, Fevrier, ..., Decembre) and the others data because, the formula used to compute this amount is built in qlikview script.

Re. :Re: Re. :Re: DAta Extraction with Qlikview

Anonymous — Wed, 20 Apr 2011 11:45:47 GMT

Is it the same formula for each calculation? Just describe it in a text box and make the tex box appear conditionally. If you want the users to see the underlying values as well, you'll have to put them in a table (same dimensions + detailed values) and set it to appear conditionally? If you still can't figure it out, attach a drawing of the desired view.

Re. :Re: Re. :Re: Re. :Re: DAta Extraction with Qlikview

Thu, 21 Apr 2011 09:39:28 GMT

Hi Dilyana.

I'd like to know now if the user has clicked on a cell in a column definite (ie JANVIER, FEVRIER, ..., DECEMBRE) ?

Thanks