Separating out your format masks from calculations

gerrycastellino — Thu, 15 Oct 2015 21:36:56 GMT

Separating out your format masks from your calculations, will help you to organize and control the formats of numbers you are displaying. A change in one central place to your format mask, will update all your display expressions.

1. An Excel/.qvs file will hold the expression calculations, no formatting using Num function involved here:

vSum_Sales = sum(Sales)

2. Define variable to hold your format mask as in:

vFormat_Number = ‘#,##0’

vFormat_Decimal = ‘#,##0.0’

vFormat_Percent = ‘##0%’

3. In the QV UI, expressions tab use the Num function with one of the formats defined:

Num(vSum_Sales, vFormat_Number).

Num(vSum_Sales,vFormat_Decimal).

Gerry.

topic Separating out your format masks from calculations in QlikView

Separating out your format masks from calculations