topic Re: Need help Calling Decimal Format Variables in QlikView

Need help Calling Decimal Format Variables

craig157 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I want to be able to change the result format of several charts on a specific sheet I am working on.

I've set up the below three variables.

vFormat_NoDecimals = '+##,##0%; -##,##0%'

vFormat_1Decimals = '+##,##0.0%; -##,##0.0%'

vFormat_2Decimals = '+##,##0.00%; -##,##0.00%'

What would be the easiest way to select which format appears on my charts and etc?

I was thinking of setting up another three variables that would change the active status from 0 to 1 but just want to see what everyone thinks before I try setting it up.

Thanks,

Craig

Re: Need help Calling Decimal Format Variables

Anil_Babu_Samineni — Wed, 08 Nov 2017 11:45:49 GMT

What are you going to get using this variable?

Re: Need help Calling Decimal Format Variables

craig157 — Wed, 08 Nov 2017 11:51:38 GMT

So in my chart I display a value like "Colour Ratio 45%" which would use vFormat_NoDecimals.

Ideally it would use these variables like this:

vFormat_NoDecimals

vFormat_1Decimals

vFormat_2Decimals

Hope this makes sense.

Re: Need help Calling Decimal Format Variables

Anil_Babu_Samineni — Wed, 08 Nov 2017 11:55:11 GMT

Normally, Expression should be

Num(Expression, 'Your Format')

Re: Need help Calling Decimal Format Variables

craig157 — Wed, 08 Nov 2017 11:58:43 GMT

Anil - that is already happening... I am trying to make the 'Your Format' into a variable I can change to the three variables I've already advised so we can have different formats depending on the Users Selection.

Re: Need help Calling Decimal Format Variables

Anil_Babu_Samineni — Wed, 08 Nov 2017 12:05:21 GMT

See, Normally how this happens

SET vFormat_NoDecimals = '+##,##0%; -##,##0%'

SET vFormat_1Decimals = '+##,##0.0%; -##,##0.0%'

SET vFormat_2Decimals = '+##,##0.00%; -##,##0.00%'

And then Num(Sum(Measure), vFormat_NoDecimals)

Re: Need help Calling Decimal Format Variables

craig157 — Wed, 08 Nov 2017 14:59:14 GMT

Thanks Anil,

So now I have a new issue!

In my equation I've got a new variable vFormat_FormatSelecter which I will assign vFormat_NoDecimals too when a button is selected. And another button for vFormat_2Decimals and etc.

Unfortunately when entered this way it is just bringing up the text name of the variable and not formatting the answer.

Any ideas?

Thanks

Re: Need help Calling Decimal Format Variables

Anil_Babu_Samineni — Wed, 08 Nov 2017 15:08:46 GMT

Not sure i followed, Can you help us to show the expected result. That would be offer more clear rather functional. And what i understand is Auto Hide show objects.

Re: Need help Calling Decimal Format Variables

craig157 — Wed, 08 Nov 2017 15:24:58 GMT

See the images I sent previously would be the end result....

So I would define the original equation to be:

vFormat_FormatSelecter

On another section of my layout I have three buttons that set the variable vFormat_FormatSelecter

Button 1 - vFormat_NoDecimals this has been set as '+##,##0%; -##,##0%'

Button 2 - vFormat_1Decimals this has been set as '+##,##0.0%; -##,##0.0%'

Button 3 - vFormat_2Decimals this has been set as '+##,##0.00%; -##,##0.00%'

Re: Need help Calling Decimal Format Variables

Anil_Babu_Samineni — Wed, 08 Nov 2017 15:34:30 GMT

True, In each image you need to use all buttons, But unfortunately button doesn't have future called Number format in Qlikview.

1) Create 3 buttons and assign variable with empty value and then call them as in Button with Variable from external section to each chart

2) Finally, You could call each variable to each chart of format where you are indeed.