Sorting based on partcular value not in ascending or descending order.

[#1]

Hi All,

I have the data like below in staright table.

Column A

    G

      R

      W

      Y

I want to see tha data like

Column A

      R

       G

        Y

       W

I mean not in ascending/Descending order.I gave the sample data and user need to the data as above format.

I have to show the data format like this in number of fields.

Is it possible in qlikview?

Thanks,

Raviteja

[Gysbert_Wassenaar]

It's easiest to create the sort order in the script. See this blog post. Alternatively you can use the Sort by Expression option and use as expression =match('R','G','Y','W'). The disadvantage is that you'll have to do this in every object where you want this sorting order. So, creating the sort order in the script is probably less work.

[Kushal_Chawda]

You can define a sort order in script using inline table. Use that field in expression of sort tab.

see the attached application