Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

happyjoshua777
Contributor

FTE % to Total Straight table p. 336 in Qlikview for Devs book

Hello,

I have followed the steps to create a straight table in Qlikview 11 for Devs and ended up with very strange results (refer to table.png attached). I have also attached screen shot of relevant tabs, as well as the Edit Expressions panel.

I have also attached expected_result.png which displays the table one is meant to come up with.

May I ask you, where have I gone wrong?

thanks

Tags (1)
4 Replies
MVP
MVP

Re: FTE % to Total Straight table p. 336 in Qlikview for Devs book

In the number tab, flag "Show in percent (%)"

happyjoshua777
Contributor

Re: FTE % to Total Straight table p. 336 in Qlikview for Devs book

I did that and now the total is 1,00% and the rest are very small numbersproperties_changed.png

Not applicable

Re: FTE % to Total Straight table p. 336 in Qlikview for Devs book

Can you select two decimals for the fixed to option and see that the format is #,##0.00% after selection of "Show in Percent(%)" option

happyjoshua777
Contributor

Re: FTE % to Total Straight table p. 336 in Qlikview for Devs book

I did that and now the results are even more ridiculous

ta

fixed_to_2_dec.png