topic Display a value as feet (') and inches (") in QlikView

Display a value as feet (') and inches (")

DataKnight1 — Fri, 15 Nov 2024 23:50:23 GMT

Hi,

I'm assuming this will be relatively easy, and hopefully save me some time! I'm wanting to change the way two separate values are displayed and want to do this in the load script.

I have a value, for example;

I want to display this as feet;

20'

I have another value, for example;

I want to display this as inches;

Firstly, how would this be achieved?

My end result, after combining the two fields will be;

20' 6"

Thanks

Re: Display a value as feet (') and inches (")

MayilVahanan — Fri, 09 Oct 2020 08:49:52 GMT

Hope you have 2 fields like below

Load *, Feet&chr(39)&Inch&'"' as FeetInch Inline
[
Feet, Inch
20, 6
];

Feet&chr(39)&Inch&'"' as FeetInch <-- helps to achieve the expected results.

Regards,

Mayil Vahanan R

Re: Display a value as feet (') and inches (")

DataKnight1 — Fri, 09 Oct 2020 08:54:34 GMT

Hi Mayil,

Thanks for your prompt response.

Whilst your solution would fix the specific values in question - what if there were thousands? I don't want to key each one in an INLINE table...

Eg;

So may aim is to reformat the fields in script so they display as;

1'0"

2'0"

3'0"

4'0"

4'6"

etc...

Re: Display a value as feet (') and inches (")

MayilVahanan — Fri, 09 Oct 2020 09:04:38 GMT

Hi,

Actually, I've provided the sample data & solution.

In your script, you can use like below

YourFeetFieldName&chr(39)&YourInchFieldName&'"' as FieldInch

Re: Display a value as feet (') and inches (")

DataKnight1 — Fri, 09 Oct 2020 09:07:26 GMT

Great - thanks very much!

Have a good day.

Simon