topic Re: Number and date format in QlikView

Number and date format

Tue, 29 Sep 2015 15:00:38 GMT

1.I have list box with number format as 0.00%,How can I dispaly as 0%..no decimals.

2.I have date as 10/1/2015,how can I chnage the format to 10/1/15

Thank you very much.

swuehl — Tue, 29 Sep 2015 15:02:12 GMT

Either change the number format on number tab of the list box or format the field when creating appropriately.

vijetas42 — Tue, 29 Sep 2015 15:20:19 GMT

Hi,

You can change the number format of your dimension field from number tab

if you want % with no decimal then check number format as fixed to and also check show in percent option

If you want to change date then you can select number format as date and in format you can change 'YYYY' to 'YY' .