Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

sorting in alphanumeric order

Hi,

I have two drop downs, one with Countries and the other with Product codes.

I need to sort the product codes in alphanumeric order.

We also have sectional access in which specific users have access to only one specific country.

When i sort the product codes in alphanumeric order, it appears in order only to those who have access to all the countries.

But for country specific users, the sorting fails.

Is there a way to sort the product codes so that it do not fail for country specific user as well as for those who have access to all countries.

Example :

Input file:

Country                      Product Code

Canada                       Z168

Russia                        Z437

Canada                       X181

Russia                        A284

Canada                       A123

I need the output something like this :

Country                     Product Code

Canada                       A123

Canada                       X181

Canada                       Z168

1 Reply
Anil_Babu_Samineni

When you say output you can use in script

Load * From Table where Country Like 'Canada';

Front end

If(Match(Country, 'Canada'), Country) // Calculated Dimension

Only({<Country = {'Canada'}>} Country) // Measure

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful