topic Re: How to sort based on 2 string values in QlikView

How to sort based on 2 string values

Anonymous — Thu, 03 Mar 2016 07:31:30 GMT

I have 2 columns Group and Function , I need to sort Function based on Group values and retrieve the first Function value based on Group values

Group Values

Agent

Billing

Functions values

ABC

BBB

CCC

DDD

Association between Group and Function is as below :

Agent - ABC

Agent - BBB

Billing - CCC

Billing - DDD

I need to get ABC value

Thanks!

Anonymous — Thu, 03 Mar 2016 07:40:30 GMT

Didnt understand you properly, might be asking to sort this order as per your requirement...

Properties-> Sort-> Expression to sort

Expression:

IF(Grounp&FunctionField='Agent - ABC', 1,

IF(Grounp&FunctionField='Agent - BBB', 2,

IF(Grounp&FunctionField='Agent - CCC', 3,

IF(Grounp&FunctionField='Agent - DDD', 4))))

With above expression you can change the order, hope this well help!!

Thu, 03 Mar 2016 07:42:31 GMT

Hi Ramya ,

Have a nice day.

Small clarification where your trying to do the sorting

any Object or edit script.

Digvijay_Singh — Thu, 03 Mar 2016 08:16:56 GMT

try Firstsortedvalue([Group Values],[Functions values]

avinashelite — Thu, 03 Mar 2016 12:19:32 GMT

could please explain what your trying to achieve ?? what value you need from the function ?

please share the sample output and data so that it will be helpful for us to understand