topic Re: How to segregate a field value into two without changing edit script ? in QlikView

How to segregate a field value into two without changing edit script ?

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

Hi All ,

I have a field Rating . Rating has following values

Rating

2/5

1/3

5/10

5/5

I want to do calculation like 2 + 5/2 , 1+3/2 , 5+10/2 ..etc . I want to achieve this on UI . I do not want to alter edit script .

Thanks & Regards

Shekar

Re: How to segregate a field value into two without changing edit script ?

shekhar_analyti — Tue, 16 Jan 2018 07:04:35 GMT

I have handled this using substring at script level , but req is to achieve same at UI level ..

Re: How to segregate a field value into two without changing edit script ?

Anil_Babu_Samineni — Tue, 16 Jan 2018 07:09:52 GMT

Substring future works both level either script and UI will work

Re: How to segregate a field value into two without changing edit script ?

shekhar_analyti — Tue, 16 Jan 2018 07:14:40 GMT

Hi Anil ,

Thanks for reply . Is there any other way , i am just curious to know . Because i have huge data and i do not want to take toll on performance . Please suggest

Re: How to segregate a field value into two without changing edit script ?

Anil_Babu_Samineni — Tue, 16 Jan 2018 07:16:40 GMT

Before discuss, can we know your intend ?

Re: How to segregate a field value into two without changing edit script ?

shekhar_analyti — Tue, 16 Jan 2018 07:24:53 GMT

Hi Anil ,

I have to use numeric values in field separated by '/' for calculation i mentioned . I do not want to make any change in data script .

Re: How to segregate a field value into two without changing edit script ?

tresB — Tue, 16 Jan 2018 07:31:00 GMT

This?

=SubField(Rating, '/',1)+SubField(Rating, '/',2) /2

Re: How to segregate a field value into two without changing edit script ?

shekhar_analyti — Tue, 16 Jan 2018 07:42:05 GMT

Hi Tresesco ,

I have used This already as well .

Re: How to segregate a field value into two without changing edit script ?

tresB — Tue, 16 Jan 2018 07:53:58 GMT

Isn't that working? Or you are just looking for alternatives. If so try one more option:

=Replace(Rating, '/','+') / SubField(Rating, '/',1)

Or,

=$(=Replace(Rating, '/','+')) / SubField(Rating, '/',1)

Re: How to segregate a field value into two without changing edit script ?

shekhar_analyti — Tue, 16 Jan 2018 08:23:17 GMT

Yeah ... actually looking for alternatives .. which should not make my existing application heavy ..

Re: How to segregate a field value into two without changing edit script ?

shekhar_analyti — Tue, 16 Jan 2018 08:41:00 GMT

=Replace(Rating, '/','+') / SubField(Rating, '/',1)

Or,

=$(=Replace(Rating, '/','+')) / SubField(Rating, '/',1)

Above is Not working

Re: How to segregate a field value into two without changing edit script ?

tresB — Tue, 16 Jan 2018 09:35:22 GMT

Without selecting a single value, $ expansion solution would not work. You could find alternate solution using various string-functions, like - index(), textbetween(), mid().... However, with such variations, there would not be a major performance difference in UI. Hence, you can stick to subfield() solution.