topic % by column and row to a PivotTable in QlikView

% by column and row to a PivotTable

Fri, 18 Sep 2015 11:17:54 GMT

Hello, I have the same problem but with a formula SET ANALYSIS, I tried the formula proposed by OKG but it does not give me the right result. I have a PivotTable with two dimensions: source of employment year

Count (DISTINCT {$ <contract = {'CDI'} between {= '1'}>} [id_salarie]): nbr of CDI hirings

I want to have for each year, the% of each source hiring

The formula I tried

Count (DISTINCT {$ <contract = {'CDI'} between = {'1'}>} [id_salarie]) / count (DISTINCT total <year> {$ <contract = {'CDI'} between = {'1 '}>} [id_salarie])

The formula gives me the% from the total of all years

Help please !

(posted edited by OKG; translation done by Google Translate)

Re: % by column and row to a PivotTable

marcus_sommer — Fri, 18 Sep 2015 12:49:38 GMT

Try something like this:

Count ({$ <contract = {'CDI'}, between = {'1'}>} DISTINCT [id_salarie]) /

Count ({$ <contract = {'CDI'}, between = {'1'}>} DISTINCT total <year> [id_salarie])

- Marcus

Re: % by column and row to a PivotTable

Fri, 18 Sep 2015 14:38:33 GMT

Thank you Marcus but it gives the same result that i have with my formula !

Re: % by column and row to a PivotTable

marcus_sommer — Fri, 18 Sep 2015 14:51:54 GMT

Normally this approach worked to get the quotes. Maybe there are other things to be considered - is more than one year available - this might be restricted by other selections or are there alternate states and is this year-field a dimension within the chart?

- Marcus

Re: % by column and row to a PivotTable

Fri, 18 Sep 2015 16:29:46 GMT

Marcus, the year field is a dimension of the table and I verified that i have no selection. Below is my pivot table:

Re: % by column and row to a PivotTable

marcus_sommer — Fri, 18 Sep 2015 17:30:27 GMT

You need your other dimension Source also within the total statement: total <year, Source>

- Marcus

Re: % by column and row to a PivotTable

satheshreddy — Wed, 21 Dec 2016 14:13:16 GMT

Hi Amoira,

Are You tried in Number Tab we can select Particular Exp and select Integer And Check the show in percentage, may it will comes % entire Hiring Column.

Regards

Sathish