topic Re: % Formatting defined in script not working in pivot table in QlikView

% Formatting defined in script not working in pivot table

helen_pip — Fri, 16 Oct 2015 10:28:53 GMT

Hello

I ham defining my % expression in the script and referring to the value in a pivot table

My expression is:

num(sum(if(ED_Did_Not_Wait=1,1,0))/sum(InYTDInd), '0,0%' )

I have used this format in numerous tables before it it gives me an output of I.e. 3.45%

However when I load the script, the value in my pivot table comes out as 0.345124315315315313 and I want to show 3.45%

I have defined the format in my script also:

SET Percentage = '0.0%'

NB: In my pivot table, I also have values in a hh:mm format. Can I have more than 1 value type in a pivot table?

Does anyone have any suggestions as to why my % is not showing the desired format?

Kind Regards

Helen

Re: % Formatting defined in script not working in pivot table

miguelbraga — Fri, 16 Oct 2015 10:33:56 GMT

Try to change your expression to this please:

=num(sum(if(ED_Did_Not_Wait=1,1,0))/sum(InYTDInd), '# ##0,00%' )

Maybe this could solve your problem

Re: % Formatting defined in script not working in pivot table

Kushal_Chawda — Fri, 16 Oct 2015 10:46:54 GMT

Use the expression

sum(if(ED_Did_Not_Wait=1,1,0))/sum(InYTDInd)

Now got to Number tab of Pivot table properties -> change Number Format setting , select Fixed to -> Select 2 Decimal-> check the show in Percent(%)

Re: % Formatting defined in script not working in pivot table

Fri, 16 Oct 2015 10:54:56 GMT

Try This Format

=num(sum(if(ED_Did_Not_Wait=1,1,0))/sum(InYTDInd), '#,##0.00%' )

Hope its HelpFull To you

Re: % Formatting defined in script not working in pivot table

helen_pip — Fri, 16 Oct 2015 11:06:24 GMT

Hello

Thank you for your response

I managed to get the % to show by writing the expression as

num(sum(if(ED_Did_Not_Wait=1,1,0))/sum(InYTDInd), '0.00%')

However, I only got it to work by taking out all other expressions. All other expressions in my pivot table are in hh:mm format and as I am defining the format in the script, it appears that the pivot table will on ly accept 1 formatting type.

I wanted to do as much work for the pivot table in the script, but am now thinking of doing the formatting in the table itself.

Have you heard of pivot tables only showing 1 type of formatting when all is defined in the script?

Kind Regards

Helen

Re: % Formatting defined in script not working in pivot table

helen_pip — Fri, 16 Oct 2015 11:07:21 GMT

Hello

Thank you for your response

I managed to get the % to show by writing the expression as

num(sum(if(ED_Did_Not_Wait=1,1,0))/sum(InYTDInd), '0.00%')

I wanted to do as much work for the pivot table in the script, but am now thinking of doing the formatting in the table itself.

Have you heard of pivot tables only showing 1 type of formatting when all is defined in the script?

Kind Regards

Helen

Re: % Formatting defined in script not working in pivot table

Fri, 16 Oct 2015 12:05:44 GMT

Try this Expression it will work

num((sum(if(ED_Did_Not_Wait=1,1,0))/sum(InYTDInd)), '##.00 %')