topic Re: Selecting decimal places dynamically in QlikView

Selecting decimal places dynamically

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

Hi,

I am very much new to QlikView...just started with this tool....

I have a requirement...there is a revenue column in my dashboard, in which numbers appear till 15 decimal places. My requirement is to make an input field- in which user can put no. as per his choice(0-15), and depending upon the number inserted(0-15) decimal places should appear.

For eg:- If I say 5 decimal places, revenue in the column should appear till 5 places of decimal only.

Can you guys help me with this requirement.

Cheers

Ali

Re: Selecting decimal places dynamically

swuehl — Wed, 01 Nov 2017 10:47:49 GMT

Maybe use a variable vFormat that creates a format string from the user input vNumberOfDigits:

='#,##0.' & Repeat('0',vNumberOfDigits)

(adapt format to your needs, e.g. the integer part)

Then, in your chart, use something like

=Num( Sum(Revenue), vFormat, '.',',')

Re: Selecting decimal places dynamically

Or — Wed, 01 Nov 2017 11:09:12 GMT

Stefan's approach above should work. If you prefer modifying the actual value to get sums consistent with your display (that is, rounding it off or flooring it), you could also use:

Floor(YourValue,1/(pow(10,vNumOfDigits))

You can also replace Floor() with Round() depending on the behavior you want.

e.g. for three digits selected and a value of 1.23456, this would resolve to:

Floor(1.23456,1/10^3)

Floor(1.23456, 0.001)

1.234

Round() with the same values would result in 1.235.

Re: Selecting decimal places dynamically

freekyali — Thu, 02 Nov 2017 07:20:05 GMT

Hi,

I tried implementing, but can't get through it...can you please explain it more?

Also can you please explain the integer format and how to implement it as per the requirement?

Cheers

Ali

Re: Selecting decimal places dynamically

swuehl — Thu, 02 Nov 2017 18:42:47 GMT

Freeky Ali wrote:

Hi,

I tried implementing, but can't get through it...can you please explain it more?

Also can you please explain the integer format and how to implement it as per the requirement?

Cheers

Ali

How could I explain the integer format as per your requirement without knowing your requirement?

The format code is somewhat explained in

Conventions for number and time formats ‒ QlikView

If you need help with creating the variable for the format, then please

- specify your format requirements

- post a small sample QVW with your current status, i.e. the input field and variable definition.

Re: Selecting decimal places dynamically

freekyali — Thu, 02 Nov 2017 19:16:28 GMT

Thank you soo much for your help.

I implemented your solution and honestly speaking you just nailed it.

I was actually looking for this solution only.

Thanks again for making my day.

Cheers

Ali